Conditional Sumif Problem

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I am using a condition sumif statement to select multiple
criteria for a Financial Statement. The conditions are
the same month to month. I am wanting to be able to add
the Name "Month" to the conditional sum if statement and
just change the month so I can continue to use the same
worksheet to build the yearly data and just select what
month I want. The conditional sumif does not recognize
the cell named month. Any suggestions?

Dan
 
How about just including a cell address in your formula, and then just enter
the month in that cell?

=SUMIF(A1:A12,C1,B1:B12)

With the months listed in column A and the particular month to total being
entered in cell C1.
 
Hi Dan
you may use SUMPRODUCT:
=SUMPRODUCT((A1:A100="your_existing_condition)*(MONTH(B1:B100)=X1),C1:C
100)
X1: a number from 1-12 to represent your month if col. B stores a date,
col. C is summed and column A contains another criteria
 
Back
Top