Use an If Sum

[Guest]

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!

 

[Franz Verga]

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!

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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