Thread: Need function for one value for two criterias and two columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default Need function for one value for two criterias and two columns
Hi!

Try something like this:

Condition 1 = Yes
Condition 2 = 100
C1:C100 = range to sum

=SUMPRODUCT(--(A1:A100="Yes"),--(B1:B100=100),C1:C100)

Notice that the TEXT condition is enclosed in quotes and the NUMERIC
condition is not.

Biff

"Melanie" wrote in message
...
I've tried the SUMIF function but i really need to get one figure with two
different conditions each coming from a different column and i can't quite
find anything to do the job. Can you please help me?


Reply With QuoteReply With Quote