Summing #s while ignoring blanks...

  • Thread starter Thread starter Shhhh
  • Start date Start date
S

Shhhh

Hello all,

Before I ask my question I just want to thank you all in this group
for your amazing helpfulness... I'd be so lost without this group!
Thank you all!

Now onto business...

H2:H350 all have values...
J2:J350 are always changing. by me inputting and deleting etc..

I want to be able to sum H2:H350 ONLY if there is a value in it's
corresponding J cell...

so if J2, J3, and J20 have values add H2, H3, H20. if I put a # in J4
add H4 too.

I hope I worded my question in a way that makes sense...


thank you all again!
 
Back
Top