Excel 2003 Conditional Sum, 3 criteria

February 18, 2012 at 11:23:55
Specs: Windows Vista

I am hoping someone can please assist me.

I have the following columns set
Column A = offers
30% discount
Free Wine

Column B = channels

Column C = month

Column D = week

Column E = restaurant

Column F = restaurant
Modern European

In my report; I would like to show production figures for:
- offer per channel during specific month for specific restaurant

Production figures for:
- 30% discount on phone in month 1 in British restaurant
- 30% discount on phone in week 1 in British restaurant

=SUM(IF($A$6:$A$73="30% discount",IF($B$6:$B$73="Phone",IF($C$6:$C$73="1",$E$6:$E$73,0),0),0))

Unfornutately this is not returning anything - saying that #VALUE!

I am not sure what I have done wrong. Can any one please help?

Many thanks

See More: Excel 2003 Conditional Sum, 3 criteria

Report •

February 18, 2012 at 17:36:52
What version of Excel are you running?

Excel 2007+ has a SUMIFS function which might work for you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question