| 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
Modify the formula
=SUMIF(Data!$T$6:Data!$T$20000,"Long Term",Data!BE$6:Data!BE$20000)/sum(Data!BE$6:Data!BE$20000) with regards Sreedhar "juliejg1" wrote: 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.worksheet.functions
|
|||
|
|||
|
SUMIF Question
Works great...thanks!
"yshridhar" wrote: Modify the formula =SUMIF(Data!$T$6:Data!$T$20000,"Long Term",Data!BE$6:Data!BE$20000)/sum(Data!BE$6:Data!BE$20000) with regards Sreedhar "juliejg1" wrote: 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). |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF Question
You are most welcome. Thank for feedback.
with regards Sreedhar "juliejg1" wrote: Works great...thanks! "yshridhar" wrote: Modify the formula =SUMIF(Data!$T$6:Data!$T$20000,"Long Term",Data!BE$6:Data!BE$20000)/sum(Data!BE$6:Data!BE$20000) with regards Sreedhar "juliejg1" wrote: 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 Worksheet Functions | |||
| SUMIF Question | Excel Worksheet Functions | |||
| SUMIF Question | Excel Worksheet Functions | |||
| Sumif question | Excel Worksheet Functions | |||
Linear Mode
