Hello,
I need to count those values in col B that have the same ID as in col D and whose value is >= the corresponding value in col E but <= the value in col F as given the attached example sheet.
Any help will be highly appreciated.
Best regards,
guest
Try this formula
Formula:
Please Login or Register to view this content.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
@ Tsjallie. Thank you very much for your response. You have figured it right.
After correcting my mistake by switching the places of columns E and F, the formula becomes:
=SUMPRODUCT(--($A$2:$A$292=$D2),--($B$2:$B$292>=$E2),--($B$2:$B$292<=$F2))
and it seems to work fine.
Thanks a lot!
You could also use the more efficient COUNTIFS function...Originally Posted by guest2013
=COUNTIFS($A$2:$A$292,$D2,$B$2:$B$292,">="&$E2,$B$2:$B$292,"<="&$F2)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
@Tony Valko. Thanks a lot for your response. Your solution has taught me that I was missing the use of "&" in my countifs formula.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks