I need a formula that can sum different cells, conditioned by other cells

[cristiann0]

Hi there.
I'm new to this forum.
I'll apreciate all the help that i can get.
I will first post the xls table that I am using, and then I'll try to explain what i need

Registration a b c d a1 b1 c1 d1
4003275736 E R E E 5 4 5 3
4003276793 E R E R 1 2 2 5
4003276951 E R E R 2 4 2 2
4003277163 E R E R 0 1 1 1
4003277223 R E R E 8 8 5 1
4003277243 R E R E 7 6 3 0
4003277694 E R E R 8 9 1 2
4003277836 R E E E 2 5 8 6


The values from column a1 are connected with the simbols from column a. b1 with b, and so on.

I need a formula that can sum those numbers from a1 to d1 columns but depending of the simbols from a to d column.

More exactly for first line for simbol E i need to sum 5+5+3 and for simbol R only 4
for second line for simbol E i need to sum 1+2 and for simbol R i need to sum 2+5

This is just an example, and this can be done manualy, but i have 90000 line xls spreadsheet and imagine how much time do i need to make this sums.

So please give me a hint.

Thanks in advance

[Fotis1991]

Hi and welcome to the forum.

It looks like to need SUMIF(SUMIFS) function.

It's better for all to upload a sample workbook.

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[martindwilson]

use sumif
=SUMIF($B2:$E2,"E",$F2:$I2) =SUMIF($B2:$E2,"R",$F2:$I2)

[Ace_XL]

Are the values a,b,c,d and a1,b1,c1,d1 in different columns (from columns B-I)? If yes, use

=SUMIF(B1:E1,"E",F1:I1) for 'E' values
=SUMIF(B1:E1,"R",F1:I1) for 'R' values

and drag down

If not, we'd have to cull out these values