View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Martin G[_2_] Martin G[_2_] is offline
external usenet poster
 
Posts: 4
Default Conditional sum wizard

I am currently creating formulas using the conditional sum wizard.

The formula below is comparing 2 value's, but I would like to add another
value to compare. Unfortunately the wizard wont let me.

Is there any way around this?

=SUM(IF('Data Import'!$F$2:$F$3500="AGB",IF('Data
Import'!$H$2:$H$3500="AGH",'Data Import'!$M$2:$M$3500,0),0))

Thanks. Martin