MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
OK, I am well and truly puzzled with this one
I have a sheet which contains filters, however I need to use a countif based on criteria of the filter & I only want to count the visible names down column A
I was attempting to modify
=countif(subtotal(2,Analysis!A:A),Sheet4!J2)
But this will not work, is there a better method?
TIA
I have a sheet which contains filters, however I need to use a countif based on criteria of the filter & I only want to count the visible names down column A
I was attempting to modify
=countif(subtotal(2,Analysis!A:A),Sheet4!J2)
But this will not work, is there a better method?
TIA