SUMIF.

[GEM]

On column A I have dates, and on column B I have money ammounts.

From C1 through C12 I have the months of the year, January, February, March,
etc.

On D1 I want to add all the amounts from column B that represent the month
of January. On D2 I want to add all the amounts from column B that represent
the month of February, etc.

Is this posible with a SUMIF??

 

[Jacob Skaria]

Use SUMPRODUCT()

Col C months should be in excel date/time format formatted to display the
month. (Enter date>Right clickFormatCells>Custom>Type: mmmm)

In D1 (and copy down as required)
=SUMPRODUCT(--(TEXT(A1:A1000,"mmyyyy")=TEXT(C1,"mmyyyy")),B1:B1000)

If this post helps click Yes