# SUMIF formula (I think??)

#### lazor99

##### Board Regular
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.

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
lazor99 said:
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.

lazor99 said:
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.

Replies
2
Views
181
Replies
8
Views
140
Replies
3
Views
151
Replies
7
Views
233
Replies
2
Views
205

1,196,232
Messages
6,014,140
Members
441,805
Latest member
rwm

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back