Summing data based on a seperate column

A

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 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!
 
W

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
 
F

Francis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top