Hi,

Does anyone know if you can do a conditional sum with an AND in the criteria.

Such that I get a sum if

ColumnA = This
AND
ColumnB = That

Or is there another method for doing this sum

Hi

It's likley you can use the SumProduct function, but would need a little more info to produce an example.

MTB

Hi

Indeed SUMPRODUCT is like SUMIF on steroids.

In Excel 2007 Microsoft has created 3 new functions SUMIFS, COUNTIFS and AVERAGEIFS that can do a lot of what SUMPRODUCT can do but not everything.

During a recent visit to their campus in Redmond I showed them what I do with SUMPRODUCT and they were flabergasted. Useless to say that the creators of the new functionsdidn't become my friends.

SUMPRODUCT is at the center of my practiceas consultant and mentor. SUMPRODUCT empowers regular users and reduces substantially the programming needs.

If 5% of Excel users knew about SUMPRODUCT it would change the world of reporting and a lot of small businesses would not need to buy expensive, complex and limited reporting programs.

See an introduction on my website.

Thanks for the replies.

Got it working with DSUM (with some column labels), however it looks as though SUMPRODUCT would also have worked. I will bear SUMPRODUCT in mind for the future.

Many thanks
Mike

Micheal

See my new thread and download my file. It will change your life (as data analyst).