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

What other value would you like to compare?

Pete

On Jan 8, 3:47*pm, Martin G wrote:
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