Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |