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
|