Heloo everybody. The following is my data
No English Maths Science Social
1A1 64 28 40 32
1A10 38 10 27 16
1A11 98 88 100 90
1A12 48 30 36 30
1A13 56 60 26 36
1A14 60 44 51 68
1A15 36 10 12 22
1A16 36 6 7 6
1A17 56 44 52 48
1A18 48 26 18 36
1A19 50 42 41 42
1A2 46 38 31 24
1A20 80 66 58 60
1A21 42 24 28 20
1A22 a a a a
G1= 90
=SUMPRODUCT(--(B2:B16$G$1)) - giving 1 (actual - 0)
=COUNTIF(B2:B16,""&$G$1) - resulting 0
When i remove the "a" in the columns sumproduct is giving the correct
answer. How to get correct answer from Sumproduct. Any suggestions, pls
With regards
Sridhar