Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question
I have the following formula:
=SUMIF(Data!$T$6:Data!$T$20000,"Long Term",(Data!BE$6:Data!BE$20000/sum(Data!BE$6:Data!BE$20000))) I am having a problem in making this work. I want it to look in cells T6:T20000 to see if it says 'Long Term'. If it does then I want it to sum the corresponding 'Long Term' amounts in column BE6:BE20000 and take that summed total and divide it by the complete total of column BE6:BE20000 (regardless of what is in column T). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question
see responses to your question in another group.
-- Regards Roger Govier "juliejg1" wrote in message ... I have the following formula: =SUMIF(Data!$T$6:Data!$T$20000,"Long Term",(Data!BE$6:Data!BE$20000/sum(Data!BE$6:Data!BE$20000))) I am having a problem in making this work. I want it to look in cells T6:T20000 to see if it says 'Long Term'. If it does then I want it to sum the corresponding 'Long Term' amounts in column BE6:BE20000 and take that summed total and divide it by the complete total of column BE6:BE20000 (regardless of what is in column T). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Question | Excel Discussion (Misc queries) | |||
HELP!! SUMIF QUESTION | Excel Worksheet Functions | |||
SUMIF question | Excel Discussion (Misc queries) | |||
Question about SumIF | Excel Worksheet Functions | |||
SUMIF question | Excel Discussion (Misc queries) |