var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Conditional sum with AND
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
ColumnB = That
Or is there another method for doing this sum
It's likley you can use the SumProduct function, but would need a little more info to produce an example.
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.
Got it working
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.
See my new thread and download my file. It will change your life (as data analyst).