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:
[TABLE="width: 520"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]THING[/TD]
[TD]BRAND[/TD]
[TD]DATE[/TD]
[TD]STATUS[/TD]
[/TR]
[TR]
[TD]PEN[/TD]
[TD]BDA / FAI[/TD]
[TD]Monday,01-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]PEN[/TD]
[TD]BDA / FAI1[/TD]
[TD]Monday,01-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]RUBBER[/TD]
[TD]BDA / FAI2[/TD]
[TD]Monday,01-Jul-2013[/TD]
[TD]PENDING[/TD]
[/TR]
[TR]
[TD]PENCIL[/TD]
[TD]BDA / FAI8[/TD]
[TD]Tuesday,02-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]PENCIL[/TD]
[TD]MUC/DAN[/TD]
[TD]Tuesday,02-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]PENCIL[/TD]
[TD]PAR/ESI7[/TD]
[TD]Tuesday,02-Jul-2013[/TD]
[TD]PENDING[/TD]
[/TR]
[TR]
[TD]PENCIL[/TD]
[TD]LON/IBI7[/TD]
[TD]Wednesday,03-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]RUBBER[/TD]
[TD]BUD/DAN2[/TD]
[TD]Wednesday,03-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]RUBBER[/TD]
[TD]BUD/GRA3[/TD]
[TD]Wednesday,03-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]PEN[/TD]
[TD]STRA/MOA[/TD]
[TD]Thursday,04-Jul-2013[/TD]
[TD]PENDING[/TD]
[/TR]
[TR]
[TD]PEN[/TD]
[TD]KATB/TRO3[/TD]
[TD]Thursday,04-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]PEN[/TD]
[TD]KATB/TRO4[/TD]
[TD]Thursday,04-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]RUBBER[/TD]
[TD]KATB/TRO5[/TD]
[TD]Thursday,04-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]RUBBER[/TD]
[TD]MAIH/92[/TD]
[TD]Thursday,04-Jul-2013[/TD]
[TD]PENDING[/TD]
[/TR]
[TR]
[TD]PEN[/TD]
[TD]MAIH/PIR[/TD]
[TD]Friday,05-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]PEN[/TD]
[TD]MAIH/PIR1[/TD]
[TD]Friday,05-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]PEN[/TD]
[TD]CGN/IBI4[/TD]
[TD]Friday,05-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]PENCIL[/TD]
[TD]CGN/AMB[/TD]
[TD]Friday,05-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]PENCIL[/TD]
[TD]SBA/RAD[/TD]
[TD]Friday,05-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
[TR]
[TD]PENCIL[/TD]
[TD]SBA/HYA[/TD]
[TD]Friday,05-Jul-2013[/TD]
[TD]PENDING[/TD]
[/TR]
[TR]
[TD]PENCIL[/TD]
[TD]SBA/HYA1[/TD]
[TD]Friday,05-Jul-2013[/TD]
[TD]COMPLETE[/TD]
[/TR]
</tbody>[/TABLE]


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