ExcelBanter - Conditional sum wizard

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional sum wizard (https://www.excelbanter.com/excel-worksheet-functions/215810-conditional-sum-wizard.html)

Martin G[_2_]

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

Pete_UK

Conditional sum wizard

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

All times are GMT +1. The time now is 01:08 PM.