redspanna
Wellknown Member
 Joined
 Jul 27, 2005
 Messages
 1,577
 Office Version

 365
 Platform

 Windows
I have a sheet that contains several thousand rows of data that I will filter to get what I need.
Basically I would like a formula or maybe code that will count the number of times the number '1' is shown through the filtered rows in column K IF the date value through the filtered data in column A is equal to a date that is shown in cell A1 of sheet2.
So If date in A1 sheet2 is 30Aug14, count how many times the number 1 is shown in the same filtered data through column K
Hope this makes sense and thanks in advance
Basically I would like a formula or maybe code that will count the number of times the number '1' is shown through the filtered rows in column K IF the date value through the filtered data in column A is equal to a date that is shown in cell A1 of sheet2.
So If date in A1 sheet2 is 30Aug14, count how many times the number 1 is shown in the same filtered data through column K
Hope this makes sense and thanks in advance