Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.misc
|
|||
|
|||
SUMIF Question
Try this:
=SUMIF(Data!$T$6:$T$20000,"Long Term",Data!BE$6:BE$20000)/SUM(Data!BE$6:BE$20000) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "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). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Question
Hi Try
=SUMIF(Data!$T$6:Data!$T$20000,"Long Term",Data!BE$6:BE$20000) /sum(Data!BE$6:BE$20000) -- 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) | |||
SUMIF question | Excel Discussion (Misc queries) | |||
Question about SumIF | Excel Worksheet Functions | |||
SUMIF question | Excel Discussion (Misc queries) | |||
SUMIF question | Excel Worksheet Functions |