Count if date is between two dates and value in another column equ
 

Hi,

Don't know if this is possible but I have a large spreadsheet that details
'problem transactions'.

From this spreadsheet I want to count the number of rows where the date is
between two set dates and the value in another column equals a certain value.

For example, suppose column 'A' contains the date and column 'F' contains
other data. I want to use a formula to count the number of rows where Column
'A' is between 01/01/2000 and 31/01/2000 and column F equals 'ABCDEF'.

Is this possible?

Thanks in advance for any help, sorry if this is not very clear.

Count if date is between two dates and value in another column equ
 

One way:

Assume your start date is in J1 and your end date in J2:

=SUMPRODUCT(--(A1:A1000=J1),--(A1:A1000<=J2),--(F1:F1000="ABCDEF"))


In article ,
"mg_sv_r" wrote:

Hi,

Don't know if this is possible but I have a large spreadsheet that details
'problem transactions'.

From this spreadsheet I want to count the number of rows where the date is
between two set dates and the value in another column equals a certain value.

For example, suppose column 'A' contains the date and column 'F' contains
other data. I want to use a formula to count the number of rows where Column
'A' is between 01/01/2000 and 31/01/2000 and column F equals 'ABCDEF'.

Is this possible?

Thanks in advance for any help, sorry if this is not very clear.

Count if date is between two dates and value in another column equ
 

=SUMPRODUCT(--(A2:A200=--"2000-01-01"),--(A2:A200<=--"2000-01-30"),--(F2:F2
00="ABCDEF"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mg_sv_r" wrote in message
...
Hi,

Don't know if this is possible but I have a large spreadsheet that details
'problem transactions'.

From this spreadsheet I want to count the number of rows where the date is
between two set dates and the value in another column equals a certain
value.

For example, suppose column 'A' contains the date and column 'F' contains
other data. I want to use a formula to count the number of rows where
Column
'A' is between 01/01/2000 and 31/01/2000 and column F equals 'ABCDEF'.

Is this possible?

Thanks in advance for any help, sorry if this is not very clear.