Help in EXCEL

[pawan0712]

Hi,

i want to count with two different conditions.
For an example i have a sheet which contain my daily report with complete date and what i have made that day. like pen, pencil, rubber etc.

i want to count that how many pen for a particular day i have made?

can any one please help me!

 

[sdsurzh]

Suppose you have data from A:B.

A column Item (pen,pencil,rubber,etc)
B Column date (15-Jul-13...)


D1 AND E1 will have Pen and 15-Jul-13

Please apply the below formula in E3
=COUNTIFS(A2:A13,$D$1,B2:B13,$E$1)

Thanks,,
SK

 

[pawan0712]

Thanks SK,

it is not working in EXCEL 03.

and i want to count as below:

THING	BRAND	DATE	STATUS
PEN	BDA / FAI	Monday,01-Jul-2013	COMPLETE
PEN	BDA / FAI1	Monday,01-Jul-2013	COMPLETE
RUBBER	BDA / FAI2	Monday,01-Jul-2013	PENDING
PENCIL	BDA / FAI8	Tuesday,02-Jul-2013	COMPLETE
PENCIL	MUC/DAN	Tuesday,02-Jul-2013	COMPLETE
PENCIL	PAR/ESI7	Tuesday,02-Jul-2013	PENDING
PENCIL	LON/IBI7	Wednesday,03-Jul-2013	COMPLETE
RUBBER	BUD/DAN2	Wednesday,03-Jul-2013	COMPLETE
RUBBER	BUD/GRA3	Wednesday,03-Jul-2013	COMPLETE
PEN	STRA/MOA	Thursday,04-Jul-2013	PENDING
PEN	KATB/TRO3	Thursday,04-Jul-2013	COMPLETE
PEN	KATB/TRO4	Thursday,04-Jul-2013	COMPLETE
RUBBER	KATB/TRO5	Thursday,04-Jul-2013	COMPLETE
RUBBER	MAIH/92	Thursday,04-Jul-2013	PENDING
PEN	MAIH/PIR	Friday,05-Jul-2013	COMPLETE
PEN	MAIH/PIR1	Friday,05-Jul-2013	COMPLETE
PEN	CGN/IBI4	Friday,05-Jul-2013	COMPLETE
PENCIL	CGN/AMB	Friday,05-Jul-2013	COMPLETE
PENCIL	SBA/RAD	Friday,05-Jul-2013	COMPLETE
PENCIL	SBA/HYA	Friday,05-Jul-2013	PENDING
PENCIL	SBA/HYA1	Friday,05-Jul-2013	COMPLETE

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Now my question is, i want to count on 4th of july13, how many pens i have made?
please help me.

 

[sdsurzh]

=SUM(($A$13:$A$28="pen")*($C$13:$C$28="E1"))
confirmed with CTRL+Shift+Enter
In E1. Enter the date

 

[pawan0712]

=SUM(($A$13:$A$28="pen")*($C$13:$C$28="E1"))
confirmed with CTRL+Shift+Enter
In E1. Enter the date

nope!
Its not working.....
it is showing an error

 

[sdsurzh]

Hi,


can you please mail the workbook i will try to fix and resend.
sdsurzh@gmail.com

Thanks,
SK