created a report from actinic database in exel.
thought i was there, but when i filter the sales on my worksheet by date my formula still counts the entire column it referencees.
eg: =COUNTIF('raw order detail'!N:N,17)
allways comes back with 27 occurences no matter how i filter the dates.
its still counting hidden cells by the filter, how do i stop this.
thought i was there, but when i filter the sales on my worksheet by date my formula still counts the entire column it referencees.
eg: =COUNTIF('raw order detail'!N:N,17)
allways comes back with 27 occurences no matter how i filter the dates.
its still counting hidden cells by the filter, how do i stop this.