hey my friends
pls open the file which is attached
in 2nd worksheet (2013_filtered) , u ll see my sales number only for 2013 but when i write the formula, u see result of COUNTIFS formula again for both 2012 and 2013 is 10 . but result should be 5 for only 2013 data.
so how i should write "COUNTIFS" formula only for seen data in the table. i dont wanna "COUNTIFS" formula test hidden data when i filtered.
Bookmarks