# Excel 2003 Conditional Sum, 3 criteria

February 18, 2012 at 11:23:55
Specs: Windows Vista
 HelloI am hoping someone can please assist me.I have the following columns setColumn A = offers30% discountFree WineColumn B = channelsWebsitePhoneColumn C = month1 2Column D = week1,2,3,4,5,6Column E = restaurant BritishColumn F = restaurantModern EuropeanIn 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

#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