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).

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).

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).

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).