dual conditional sums

  • Thread starter Thread starter am
  • Start date Start date
A

am

Does anyone have a method of conditionally summing a
column based on the combination of values in two columns.

eg

Column A Column B Column C
Nov CORP $1000
Dec HO $500
Jan CORP $150
Nov HO $250

I want to sum column C where column A = Nov AND column B
= CORP

Resulting in a value of $1000

Any ideas???

Thanks in advance,

Alan
 
Hi Alan
try
=SUMPRODUCT((A1:A999="Nov")*(B1:B999="CORP"),C1:C999)
assumption: Column A stroes text and not dates which are formated as
months

HTH
Frank
 
Thanks a bunch Frank.

I was just checking out one of your solutions to an
earlier post - you got it goin' on! :)

am
 
Back
Top