Use an If Sum

S

sueledet

I want to total Column C only if Column J begins with the word Leased. Same
with Column E, only if Col J has the word Leased in it.

I think this is a function question but I'm too new to know the difference!
 
F

Franz Verga

sueledet said:
I want to total Column C only if Column J begins with the word
Leased. Same with Column E, only if Col J has the word Leased in it.

I think this is a function question but I'm too new to know the
difference!
Click to expand...

You can try to use the SUMIF function. Check the online help.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
B

Bob Phillips

=SUMIF(J:J,"Leased*",C:C)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top