मंगलवार, 25 अगस्त 2015

School Sarve report in excel method

6-10 सर्वे रिपोर्ट
=COUNTIFS(A1:A100,"<=10",B1:B100,"M",C1:C100,"BC",D1:D100,"G")

=COUNTIFS(A1:A100,"<=10",B1:B100,"F",C1:C100,"BC",D1:D100,"G")

=COUNTIFS(A1:A100,"<=10",B1:B100,"M",C1:C100,"SC",D1:D100,"G")

=COUNTIFS(A1:A100,"<=10",B1:B100,"F",C1:C100,"SC",D1:D100,"G")

11-14 सर्वे रिपोर्ट
=COUNTIFS(A1:A100,">10",B1:B100,"M",C1:C100,"BC",D1:D100,"P")

=COUNTIFS(A1:A100,">10",B1:B100,"F",C1:C100,"BC",D1:D100,"P")

=COUNTIFS(A1:A100,">10",B1:B100,"M",C1:C100,"SC",D1:D100,"P")

=COUNTIFS(A1:A100,">10",B1:B100,"F",C1:C100,"SC",D1:D100,"P")

11-14 सर्वे रिपोर्ट
=COUNTIFS(A1:A100,">10",B1:B100,"M",C1:C100,"BC",D1:D100,"G")

=COUNTIFS(A1:A100,">10",B1:B100,"F",C1:C100,"BC",D1:D100,"G")

=COUNTIFS(A1:A100,">10",B1:B100,"M",C1:C100,"SC",D1:D100,"G")

=COUNTIFS(A1:A100,">10",B1:B100,"F",C1:C100,"SC",D1:D100,"G")

6-10 सर्वे रिपोर्ट
=COUNTIFS(A1:A100,"<=10",B1:B100,"M",C1:C100,"BC",D1:D100,"P")

=COUNTIFS(A1:A100,"<=10",B1:B100,"F",C1:C100,"BC",D1:D100,"P")

=COUNTIFS(A1:A100,"<=10",B1:B100,"M",C1:C100,"SC",D1:D100,"P")

=COUNTIFS(A1:A100,"<=10",B1:B100,"F",C1:C100,"SC",D1:D100,"P")

लेबल:

0 टिप्पणियाँ:

एक टिप्पणी भेजें

सदस्यता लें टिप्पणियाँ भेजें [Atom]

<< मुख्यपृष्ठ