Hi,
Could you please help me in the attached file instruction is there in it.
Thanks in advance.
Regards,
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
=SUMPRODUCT(N($C$2:$C$11=E5),N($B$2:$B$11=A)) with cse
On Tue, Jul 2, 2013 at 6:51 AM, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hi,
Could you please help me in the attached file instruction is there in it.
Thanks in advance.
Regards,
Chandra
--
Are you =EXP(E:RT) or
Hi,
Am getting a wrong count as 2 I have changed the E5 with date.
Regard,
Chandra
On Tue, Jul 2, 2013 at 7:30 PM, priti verma pritiverma1...@gmail.comwrote:
=SUMPRODUCT(N($C$2:$C$11=E5),N($B$2:$B$11=A)) with cse
On Tue, Jul 2, 2013 at 6:51 AM, Chandra Shekar
=SUMPRODUCT(N(DATE(YEAR(C2:C11),MONTH(C2:C11),DAY(C2:C11))=DATE(2013,8,2)),N($B$2:$B$11=A))
with CSE
On Tue, Jul 2, 2013 at 7:27 AM, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hi,
Am getting a wrong count as 2 I have changed the E5 with date.
Regard,
Chandra
On Tue, Jul 2,
Try using SUM with CSE
=SUM((C2:C11C3)+((C2:C11C3)*(B2:B11=A)))
Or SUMPRODUCT
=SUMPRODUCT((C2:C11C3)+((C2:C11C3)*(B2:B11=A)))
Rgds,
[dp]
Pada 02/07/2013 20:51, Chandra Shekar menulis:
Hi,
Could you please help me in the attached file instruction is there in it.
Thanks in advance.
Regards,