Minitman wrote:
Greetings,

I am trying to get the sum for each month in a column which has thee
entire year.

So far I have:

SUMIF($B:$B,{need month and year here},$DT:$DT)

B is formatted as mm/dd/yy I need mm/yy in the formula. I can't
remember how to do this! Anyone have any ideas?

Any help would be appreciated.

TIA

-Minitman

=SUMIF(B:B,"="&A2,DT:DT)-SUMIF(B:B,""&A3,DT:DT)

where A2 is a first day date of the mont/year of interest like 1-Mar-04
and A3 houses: =EOMONTH(A2,0).

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.