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!