Formula how to count the date with multiple criteria.

[felixpanganiban]

Example:

Category Factory. Code. Date delivered

Column F1 CC 01 Jan 1, 2012
Column F1 CC 02 Feb 2, 2012
Beam F3 BM 01 Jan 3, 2012
Column F1 CC 01 Jan 1, 2012


Question:

How many delivered column in factory 1 for the month of january?

Any help from everybody?

[Ace_XL]

=SUMPRODUCT(--($A$1:$A$4="Column"),--($B$1:$B$4="F1"),--(TEXT($E$1:$E$4,"mmm-yy")="Jan-12"),$D$1:$D$4)

[felixpanganiban]

Thank you very much for you reply,

I have a problem on you formula. Please check attached file.

[Fotis1991]

Pls upload a sample workbook. Not a picture.

[Kevin UK]

Hi felixpanganiban

Assuming your table of data is in A1:D6 including headers and your dates are "REAL" dates, try:

Please Login or Register  to view this content.

Adapt the cell references and criteria to find, to suit your needs. You can put your criteria in cells an and reference them.

[felixpanganiban]

As of now, i use my ipad, may i know your email add and i will forward it to you? Thanks

[felixpanganiban]

What if i need to count only with specific date, example, how many column in factory 1 was delivered from jan 1 to 15 only. Not included jan 16 to 30.

[Kevin UK]

Then you will will have to adapt your formula

EG: =SUMPRODUCT(--($A$2:$A$6="Column"),--($B$2:$B$6="F1"),--($D$2:$D$6>=G1),--($D$2:$D$6<=F1))

Where F1 & G1 have your dates as the criteria. There are other way's as well.

[felixpanganiban]

Solved.......Thank you very much to all.