Sum values by sorting text

sigepforrest

New Member
Joined
Jan 14, 2004
Messages
7
I have a spreadsheet that has data entered in by different initials (RKJ, KCJ, and so on) in column B and and a value in column E all in the same row. I am trying to find the sum of the values in column E for each initial in column B.

Any info would be much appreciated.

Forrest
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
Take a look at the SUMIF function or at Pivot Tables.

Also, if the data is sorted on column B, you could use Subtotals.
 

sigepforrest

New Member
Joined
Jan 14, 2004
Messages
7
I tried another SUMPRODUCT like I did for the month. Here is what I have so far but it isnt working yet: =SUMPRODUCT(((B2:B500)=RKJ),E2:E500)

Forrest
 

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959

ADVERTISEMENT

You can do a simple SUMIF:

=SUMIF(B2:B500,"RKJ",E2:E500)
 

sigepforrest

New Member
Joined
Jan 14, 2004
Messages
7

ADVERTISEMENT

Thank you Juan, that works great. Now what if I wanted to sort by date that is in column A. Here is what i am using now and it gives me sum of all values for all initials: =SUMPRODUCT(--(MONTH(A2:A500)=1),D2:D500) and i do this for every month( 1-12). Can I combine the two functions to just give me the sums of the totals in column D by a specific month and by a specific initial.

Forrest
 

sigepforrest

New Member
Joined
Jan 14, 2004
Messages
7
But all I am trying to do is now incorporate the SUMIF used for initials and add it into the SUMPRODUCT used for the month.

Forrest
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
sigepforrest said:
But all I am trying to do is now incorporate the SUMIF used for initials and add it into the SUMPRODUCT used for the month.

Forrest

Paddy's suggestion might well worth looking into. However,

=SUMPRODUCT(--(MONTH(A2:A500)=1),--(B2:B500="RKJ"),D2:D500)

change the ranges to suit your needs.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,343
Messages
5,635,742
Members
416,876
Latest member
Sokali

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top