Hi Babu,
Please find attached.
Hi Babu,
Please find attached.
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
The formula you used in your attachment was this...Originally Posted by Admin
=SUMPRODUCT(--($B$2:$B$25>=E2),--($B$2:$B$25<F2))
An alternate formula that will produce the same results is this...
=COUNTIF(B$2:B$25,"<"&F2)-COUNTIF(B$2:B$25,"<"&E2)
I am not sure which of these two formulas would be more efficient. In my experience, the SUMPRODUCT function tends to be slow because, underneath it all, it is actually an array function that does not require using CTRL+SHIFT+ENTER to enable the array; however, making two COUNTIF function calls against the same data set might also be slow... I am just not sure.
Last edited by Rick Rothstein; 03-25-2012 at 11:48 PM.
Posting Permissions
Reply With Quote
Bookmarks