SUMIF formula (I think??)

[lazor99]

I know this formula would sum all daily data entries for "NAME" for the current year, but how would I change the formula to sum "NAME" for current months totals.

When a new month passes, the total restarts

=SUMIF(A1:A365,"NAME",C1:C365)

A1:A365 col. contains different "NAMES"
B1:B365 col contains yearly dates (11/14/2005)
C1:C365 col. contains daily ($) data entries.

Thanks.

 

[just_jon]

I know this formula would sum all daily data entries for "NAME" for the current year, but how would I change the formula to sum "NAME" for current months totals.

When a new month passes, the total restarts

=SUMIF(A1:A365,"NAME",C1:C365)

A1:A365 col. contains different "NAMES"
B1:B365 col contains yearly dates (11/14/2005)
C1:C365 col. contains daily ($) data entries.

Thanks.

=SUMPRODUCT(--(A1:A365=D1),--(TEXT(B1:B365,"mmmyy")=TEXT(TODAY(),"mmmyy")),C1:C365)

Where D1 holds the NAME of interest.

 

[Aladin Akyurek]

I know this formula would sum all daily data entries for "NAME" for the current year, but how would I change the formula to sum "NAME" for current months totals.

When a new month passes, the total restarts

=SUMIF(A1:A365,"NAME",C1:C365)

A1:A365 col. contains different "NAMES"
B1:B365 col contains yearly dates (11/14/2005)
C1:C365 col. contains daily ($) data entries.

Thanks.

A language-independent formula would be:

Let E2 house a name of interest and F2 the formula:

=TODAY()-DAY(TODAY())+1

which gives you the first day date of the month/year of interest.

Now you can invoke:

=SUMPRODUCT(--($A$1:$A$365=E2),--($B$1:$B$365-DAY($B$1:$B$365)+1=F2),$C$1:$C$365)

to obtain the total for the current month.