Sum of column c if column a and b matches

[ANDRE LE ROUX]

Hi
I would like to create a formula in E2, E3, E4 etc, that would count the values in C:C, if, B:B = YES and the date in A:A matches day of month in D2, D3, D4 etc.

Thanx

[outofthehat]

There's a wonderful function introduced in 2007 called SUMIFS, which will do exactly what you want. Unfortunately that doesn't help when using 2003. So we need to be creative to be able to use SUMIF.

See attached. What I've done is combine the date and the YES into a single value by concatenating text with & (I've included a / to make it read more easily in the column!). Note that the date is a number, so I need to define the format to use, using the TEXT function.

Then, on the right hand side, I've used SUMIF to sum up column D, based on the value in column C. The formula in the first bit of the SUMIF defines what I'm looking for, i.e. date/YES, with the date formatted correctly.

[ANDRE LE ROUX]

Sorry I havent replied yet!! Thanx a lot for your help on this, I also managed to figure this sumif out that also works: =SUM(IF($A$2:$A$65536=D5,IF($B$2:$B$65536="YES",$C$2:$C$65536))) (CFE). Now I also no how to combine to columns, Thanx again