Thread: How do I test values in 2 different columns in a "sumif" formula?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default How do I test values in 2 different columns in a "sumif" formula?
Try something like this:

=SUMPRODUCT(--(A1:A10="some_text"),--(B1:B10="some_text"),C1:C10)

Better to use cells to hold the criteria:

E1 = whatever
E2 = whatever

=SUMPRODUCT(--(A1:A10=E1),--(B1:B10=E2),C1:C10)

Biff

"SteveS" wrote in message
...
I want to sum values in column C based on a test of text values in columns
A
& B. Sumif only seems to support testing the value of one column not two.
Is there a way to accomplish my goal?






Reply With QuoteReply With Quote