Thread: Can I use sumif with OR to sum based on two column criteria?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dlb dlb is offline
external usenet poster
  
Posts: 12
Default Can I use sumif with OR to sum based on two column criteria?
Thanks David! It works as advertised!

"David Biddulph" wrote:

=SUMPRODUCT((A3:A6="A")+(A3:A6="B"),--(B3:B6="C"),C3:C6)
--
David Biddulph

"DLB" wrote in message
...
I am try to use sumif on two different criteria, but the first criteria
could
be "A" or "B".

Somthing like this:
=SUMPRODUCT(--(A3:A6="A" OR "B"),--(B3:B6="C"),C3:C6)

Not even sure if Sumproduct is the right path to follow.

Any thoughts?





Reply With QuoteReply With Quote