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!