Excel 2003 Conditional Sum, 3 criteria

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

I am hoping someone can please assist me.

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

Column B = channels
Website
Phone

Column C = month
1
2

Column D = week
1,2,3,4,5,6

Column E = restaurant
British

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

Eg:
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 •

#1
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