Sum values by sorting text

[sigepforrest]

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

 

[Juan Pablo González]

Take a look at the SUMIF function or at Pivot Tables.

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

 

[bhmcpfs]

SUMIF or SUMPRODUCT should do the trick.

 

[sigepforrest]

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]

You can do a simple SUMIF:

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

 

[Brian from Maui]

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

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

should suffice.

Sumproduct is used for multi-conditional counting and/or summing

see,

http://www.mrexcel.com/wwwboard/messages/8961.html

 

[sigepforrest]

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

 

[PaddyD]

you really should investigate pivot tables.

 

[sigepforrest]

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]

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.