SUMIF.

  • Thread starter Thread starter GEM
  • Start date Start date
G

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??
 
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
 
Back
Top