Hello there,
Need help on sumproduct formula that only count on visible cells & excludes any hidden rows.
I tried using this formula to the sample provided below:-
=SUMPRODUCT(--(YEAR(C3:C7)=2006)
However, it returns with overall 2006 dates, which means it's also counting those hidden cells. When I select the Type of Site as Sharing, I get 4 instead of 2. Any help on this please.
4
Site No Type Quotations date
Site 1 Sharing 11-Jan-06
Site 2 Non Sharing 05-Jan-06
Site 3 Sharing 07-Jan-06
Site 4 Sharing 20-Dec-05
Site 5 Non Sharing 03-Jan-06
Need help on sumproduct formula that only count on visible cells & excludes any hidden rows.
I tried using this formula to the sample provided below:-
=SUMPRODUCT(--(YEAR(C3:C7)=2006)
However, it returns with overall 2006 dates, which means it's also counting those hidden cells. When I select the Type of Site as Sharing, I get 4 instead of 2. Any help on this please.
4
Site No Type Quotations date
Site 1 Sharing 11-Jan-06
Site 2 Non Sharing 05-Jan-06
Site 3 Sharing 07-Jan-06
Site 4 Sharing 20-Dec-05
Site 5 Non Sharing 03-Jan-06