If statement using criteria 1

[harleynana]

Is there a way to sum up all values in a spreadsheet based on two criteria? I am trying to pull in all accts for a specific division. I have a column for the division and if it equals FE, and a column for ACCT. and if it equals 750, How do I get the two criterias combined for one total...

 

[jonsi]

You need to use the SUMPRODUCT function. I had a similar need and this answered it beautifully.

Jonsi B-)

 

[bluedragon2]

Take a look at FAQ69-4725 for an explantion...



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...