chungtinhlak
12-19-2008, 12:41 PM
{=COUNT(IF($E$48:$E$881>$G$7,IF($E$48:$E$881<=$H$7,IF($F$48:$F$881=$B29,$IV$48:$IV$881))))}
can that work? I'm taking over a workbook that someone has created and that that's what the formula shows.
when I open it, all the cell with formula has value in it, but if I click on it and press entered, the value will be one and the formula will no longer contains "{".
does column goes out that far, IV48, that's too far out of the range right?
the formula that I want goes something like this.
=if(and(E48>B6,E48<=E7,F48=B29)
but I want to count total that met this condidtion for the range from 48:883
can you guys help me.
I tried to digest the old formula but it just doesn't make sense.
Can and do =if(and(E48>B6,E48<=E7,F48=B29),1,"") and do this for all the rows and count the 1, but I have many columns that I have to do this on.
but it would really help me if there is a quicker way.
Thanks in advance.
thanks
attached is my sample worksheet, row 29 contains the old formula and starting from R48 dow and my formula, I want to combine those into 1 step and do it for all.
thanks
can that work? I'm taking over a workbook that someone has created and that that's what the formula shows.
when I open it, all the cell with formula has value in it, but if I click on it and press entered, the value will be one and the formula will no longer contains "{".
does column goes out that far, IV48, that's too far out of the range right?
the formula that I want goes something like this.
=if(and(E48>B6,E48<=E7,F48=B29)
but I want to count total that met this condidtion for the range from 48:883
can you guys help me.
I tried to digest the old formula but it just doesn't make sense.
Can and do =if(and(E48>B6,E48<=E7,F48=B29),1,"") and do this for all the rows and count the 1, but I have many columns that I have to do this on.
but it would really help me if there is a quicker way.
Thanks in advance.
thanks
attached is my sample worksheet, row 29 contains the old formula and starting from R48 dow and my formula, I want to combine those into 1 step and do it for all.
thanks