Help need for sumif function.

[shajid73]

	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

 

[Aladin Akyurek]

Cell references must be outside quotes...

=SUMIFS(C7:L7,C6:L6,">"&C6,C6:L6,"<"&L6)

 

[shajid73]

Thanks

 

[Aladin Akyurek]

Thanks

You are welcome.