Summing data based on a seperate column
 

Hello,
I'm trying to add figures in a column only if there is an 'S' in anyone of
the cells of another column. Example: Adding F7:F33 only if D7:D33 has an S
in it. I would like the result to show in C37. Note: I already have a total
count of S's from D7:D33 in C36.
I tried using formula: =SUM(F7:INDEX(F7:F33,C36)). It worked at first, but
then went wacky.
Thanks for any ideas!

Summing data based on a seperate column
 

if you want to sum the values in F7:F33 based on the condition if any of
the cells in D7:D33 has a S
try
=SUMIF(D7:D33,"S",F7:F33)
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"ADC76" wrote:

Hello,
I'm trying to add figures in a column only if there is an 'S' in anyone of
the cells of another column. Example: Adding F7:F33 only if D7:D33 has an S
in it. I would like the result to show in C37. Note: I already have a total
count of S's from D7:D33 in C36.
I tried using formula: =SUM(F7:INDEX(F7:F33,C36)). It worked at first, but
then went wacky.
Thanks for any ideas!

Summing data based on a seperate column
 

Something wrong with SUMIF?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"www.NavigatorUtilities.com" .(donotspam).
wrote in message ...
Hello,

Always advisable to do one step at a time. Have a working column that at
first identifies the numbers with the corresponding "s" with a formula
like
=IF(ISERROR(FIND("s",D7,1)),"",D7)

Step 2 Add the numbers together.

Let me know how you go
--
www.NavigatorUtilities.com

The Essential Excel Tool


"ADC76" wrote:

Hello,
I'm trying to add figures in a column only if there is an 'S' in anyone
of
the cells of another column. Example: Adding F7:F33 only if D7:D33 has
an S
in it. I would like the result to show in C37. Note: I already have a
total
count of S's from D7:D33 in C36.
I tried using formula: =SUM(F7:INDEX(F7:F33,C36)). It worked at first,
but
then went wacky.
Thanks for any ideas!

Summing data based on a seperate column
 

Thanks Francis. That worked perfectly! I appreciate the help.
ADC76

"Francis" wrote:

if you want to sum the values in F7:F33 based on the condition if any of
the cells in D7:D33 has a S
try
=SUMIF(D7:D33,"S",F7:F33)
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"ADC76" wrote:

Hello,
I'm trying to add figures in a column only if there is an 'S' in anyone of
the cells of another column. Example: Adding F7:F33 only if D7:D33 has an S
in it. I would like the result to show in C37. Note: I already have a total
count of S's from D7:D33 in C36.
I tried using formula: =SUM(F7:INDEX(F7:F33,C36)). It worked at first, but
then went wacky.
Thanks for any ideas!