Conditional sum wizard

M

Martin G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Attn: Bob Phillips (or any expert!)... help with formula 7
Conditional Sum without Range Parameters 5
Math help 3
CONDITONAL SUM DATE RANGE ISSUE 10
Conditional Sum Wizard 4
SumProduct Question 4
Conditional sum 1
Wildcard for Conditional Sum Wizard statement. 3

Top