Sum If using 2 criterias
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.
|