Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|