Without VB coding, I need to run a simple SUMIF where the condition is case dependent. Please see the attachment.
I've tried EXACT, but that's not for this purpose.
Thanks for the help.
Without VB coding, I need to run a simple SUMIF where the condition is case dependent. Please see the attachment.
I've tried EXACT, but that's not for this purpose.
Thanks for the help.
hi afgoody. that's not possible with SUMIF. try SUMPRODUCT:
=SUMPRODUCT(--(EXACT($A$1:$A$4,"C")),--($B$1:$B$4))
and if Column B is always 1, simply:
=SUMPRODUCT(--(EXACT($A$1:$A$4,"C")))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Great, thanks. I'll use the first one as the numbers won't always be 1.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks