Sum If using 2 criterias
<G
Biff
"Bob Phillips" wrote in message
...
Now come on Dr Valko, we need to keep our prejudice under wraps <G
Bob
"T. Valko" wrote in message
...
However, you may find that a pivot table is a more elegant solution for
your
data analysis needs.
Pivot table, elegant?
LOL! <vbg
Biff
"Dave F" wrote in message
...
You need to use SUMPRODUCT:
=SUMPRODUCT(--(A1:A10="Month"),--(B1:B10="Account"))
However, you may find that a pivot table is a more elegant solution for
your
data analysis needs.
Dave
--
Brevity is the soul of wit.
"Michael" wrote:
Hi,
I have 2 worksheets, one sheet with the columns listed below and the
other
sheet summarizes the activity entered in the first tab.
Column A = "Amount"
Column B = "Account"
Column C = "Month"
What I am trying to do is: SUMIF("Month"=Cell(C3) and "Account" =
Cell(B6))
then return the "Amount" based on the criteria.
How would I create a formula to do just that?
Please let me know if need to further explain.
|