Use an If Sum
 

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

Use an If Sum
 

sueledet wrote:
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

Use an If Sum
 

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

--
HTH

Bob Phillips

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

"sueledet" wrote in message
...
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!
--
sueledet