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

Conditional Sum without Range Parameters 5
Math help 3
using wizard and conditional sum 1
CONDITONAL SUM DATE RANGE ISSUE 10
Conditional Arrays 1
SumProduct Question 4
Conditional Multiply and Sum 2
Wildcard for Conditional Sum Wizard statement. 3

Top