Sum a Row

[jlkirk]

Row 1, columns A-DZ I have either an "R" or a "D", all at random.
Row 2 I have data, both positive and negative numbers. What I want to do at Row 2, Column EA is sum all of the data in row 2 that has a corresponding "R" in its adjacent cell in row 1. Any ideas?
Thanks in advance.

 

[Aladin Akyurek]

Row 1, columns A-DZ I have either an "R" or a "D", all at random.
Row 2 I have data, both positive and negative numbers. What I want to do at Row 2, Column EA is sum all of the data in row 2 that has a corresponding "R" in its adjacent cell in row 1. Any ideas?
Thanks in advance.

Is it not just:

=SUMIF(A1:DZ1,"R",A2:DZ2)

 

[jeffreybrown]

Try...

=SUMIF(A1:DZ1,"R",A2:DZ2)

 

[jlkirk]

Works great, thanks!

 

[jeffreybrown]

You're Welcome...Thanks for the follow-up

 

[amerifax]

This looks a good item for the tool bucket for future use.
Thanks
Bob