Hi,
I was trying to find a total base on 2 criteria.
Say in column C1:C100 is Apple and Column E3:AI100 is APP, when both match and found it will show the value as 1.
I have the formula but it's giving me a #Value! error unless I have 1 criteria only.
Please see attached sample I'm trying to get.
Thanks in advance for your help.
Sample Count.xlsx
With countifs the ranges need to be the same size. TryFormula:
Please Login or Register to view this content.
Is this what you wanted?
=SUMPRODUCT(($C$3:$C$100=AQ3)*($E$3:$AI$100=AO3))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi everyone,
Thank you very much for your help.
It is greatly appreciated.
Glad to help & 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