Summing data based on a seperate column

[ADC76]

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 D733 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 D733 in C36.
I tried using formula: =SUM(F7:INDEX(F7:F33,C36)). It worked at first, but
then went wacky.
Thanks for any ideas!

 

[www.NavigatorUtilities.com]

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

 

[Francis]

if you want to sum the values in F7:F33 based on the condition if any of
the cells in D733 has a S
try
=SUMIF(D733,"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

 

[Don Guillett]

Something wrong with SUMIF?

 

[ADC76]

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