| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting dates in filtered column
Hi all,
I'm trying to count the number of cells that contain a date in a filtered column. I've been using the following formula, but it keeps coming back with a value of 0, even though there are 3 in the filtered row; =SUMPRODUCT(--('Fixture Status'!J3:J1000="=0"),SUBTOTAL(3,OFFSET('Fixture Status'!J3,ROW('Fixture Status'!J3:J1000)-ROW('Fixture Status'!J3),0))) Any suggestions as to where I'm going wrong?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting dates in filtered column
On Tue, 5 Mar 2013 16:01:43 +0000, curleyy wrote:
Hi all, I'm trying to count the number of cells that contain a date in a filtered column. I've been using the following formula, but it keeps coming back with a value of 0, even though there are 3 in the filtered row; =SUMPRODUCT(--('Fixture Status'!J3:J1000="=0"),SUBTOTAL(3,OFFSET('Fixtur e Status'!J3,ROW('Fixture Status'!J3:J1000)-ROW('Fixture Status'!J3),0))) Any suggestions as to where I'm going wrong?? why not just use the Subtotal(Count .... function? =subtotal(2,'Fixture Status'!J3:J1000) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the dates in a column | Excel Discussion (Misc queries) | |||
| Max of % nembers in column WITHOUT counting dates | Excel Worksheet Functions | |||
| counting dates in a column that less than 6 months from today | Excel Discussion (Misc queries) | |||
| Formula help for counting,with a column of dates and a column of n | Excel Worksheet Functions | |||
| Counting dates in a column | Excel Worksheet Functions | |||
Linear Mode
