G
Guest
I have an array of numbers and/or text values in cells A1 through E5, such as:
A B C D E
1 12 6 A Y -5
2 4 2 3 AB 9
3 GH -1 -6 0 17
4 A V R -9 3
5 2 1 6 3 8
AND I WISH TO ADD THE CELLS where the values are 0 < X < 10. IGNORE ALL
OTHER CELL VALUES.
THEREFORE, my answer will be: 6 + 4 + 2 + 3 + 9 + 3 + 2 + 1 + 6 + 3 + 8 =
47.
Please, how is this done...using the =SUMPRODUCT formula...
It is something such as:
=SUMPRODUCT(AND(A1:E5>0,A1:E5<10),A1:E5)...BUT NOT QUITE SO!!!!!!!!!!!
PLEASE ADVISE.
Thank you,
FLKulchar
A B C D E
1 12 6 A Y -5
2 4 2 3 AB 9
3 GH -1 -6 0 17
4 A V R -9 3
5 2 1 6 3 8
AND I WISH TO ADD THE CELLS where the values are 0 < X < 10. IGNORE ALL
OTHER CELL VALUES.
THEREFORE, my answer will be: 6 + 4 + 2 + 3 + 9 + 3 + 2 + 1 + 6 + 3 + 8 =
47.
Please, how is this done...using the =SUMPRODUCT formula...
It is something such as:
=SUMPRODUCT(AND(A1:E5>0,A1:E5<10),A1:E5)...BUT NOT QUITE SO!!!!!!!!!!!
PLEASE ADVISE.
Thank you,
FLKulchar