C | D | E | F | G | H | I | J | K | L | |
6 | 1-Jan-14 | 2-Jan-14 | 3-Jan-14 | 4-Jan-14 | 5-Jan-14 | 6-Jan-14 | 7-Jan-14 | 8-Jan-14 | 9-Jan-14 | 10-Jan-14 |
7 | 1.00 | 2.00 | 3.00 | 4.00 | 5.50 | 6.60 | 7.80 | 8.30 | 9.20 | 10.00 |
Please help me to sum 2nd January to 10th January. with SUMIF function. I tried. but failed.
SUMIFS(C7:L7,C6:L6,">C6",C6:L6,"<L6")
Result Shows 0
Please help me.
Md. Shajid Hossain
Dhaka
Bangladesh