Thread: How do I test values in 2 different columns in a "sumif" formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default How do I test values in 2 different columns in a "sumif" formula?
Hi Steve

=SUMPRODUCT(($A$1:$A$100="text1")*($B$1:$B$100="te xt2")*$C$1:$C$100)

Change ranges to suit, but ensure that they are of equal size.
--
Regards

Roger Govier


"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