Excel help required

**sittarah** · 8th October 2009, 10:49 PM

meray paas aik data hai jis k aik column main formula apply karnay main masla ho raha hai.Formula asal main 2 formulas ka hai.
if-else and count
actually us column main jo values misal k tor pr 7 aur 8 k darmiyan hain woh count ho gayein aur phir jo value 6 aur 7 k darmiyan hai woh aur phir issi tarha 0 tak saari main count kr loon agr koi meri help kr sakta hai tou ply meri madad gald az gald karain.
main online hi intizar kr rhi hon.
I have attatched the file there is highlighted column there are different ranges of number which i want to count between 5 to 6 and 4 to 5 and so on.
Shukriya in advance.

Allah Hafiz

**syar** · 9th October 2009, 08:17 AM

Thode se wizahat karain k Aap simple values ko count karna chahte hain ya kisi condition k tru hone per aap specific values ko count karna chahte hain jaise k aap "if-else count" ki baat kar rahe hain. for example faraz karain k cell a1 main 1 ho tu 5-6 k darmian value count ho jain etc. agar separate count karna hain jaise 0-1 ki alag, 1-2 ki alag tu 2 solution hain.

SOLUTION 1: ( IN this solution the value of 1 will be counted double)
=SUMPRODUCT(--($K$2:$K$1804<=1),--($K$2:$K$1804>=0.00))
=SUMPRODUCT(--($K$2:$K$1804<=2),--($K$2:$K$1804>=1))
=SUMPRODUCT(--($K$2:$K$1804<=3),--($K$2:$K$1804>=2))
=SUMPRODUCT(--($K$2:$K$1804<=4),--($K$2:$K$1804>=3))
=SUMPRODUCT(--($K$2:$K$1804<=5),--($K$2:$K$1804>=4))
=SUMPRODUCT(--($K$2:$K$1804<=6),--($K$2:$K$1804>=5))
=SUMPRODUCT(--($K$2:$K$1804>=6),--($K$2:$K$1804>=6))

SOLUTION 2

In this solution the value of 1 will be counted once)

=SUMPRODUCT(--($K$2:$K$1804<1),--($K$2:$K$1804>=0.00))
=SUMPRODUCT(--($K$2:$K$1804<2),--($K$2:$K$1804>=1))
=SUMPRODUCT(--($K$2:$K$1804<3),--($K$2:$K$1804>=2))
=SUMPRODUCT(--($K$2:$K$1804<4),--($K$2:$K$1804>=3))
=SUMPRODUCT(--($K$2:$K$1804<5),--($K$2:$K$1804>=4))
=SUMPRODUCT(--($K$2:$K$1804<6),--($K$2:$K$1804>=5))
=SUMPRODUCT(--($K$2:$K$1804<7),--($K$2:$K$1804>=6))

Change accordingly.

regards.