Hi There,

I have a master database filled with forumlas that pull data from 4 other sheets. I need to be able to count the different columns of data to give totals for different metrics, and I do this using =SUMPRODUCT(--(Table4[Contacted]<>"")) to ignore the blank cells containing forumlas and count only values.

However, when I filter my columns on my master database, I don't get a filtered total. Normally I would use the subtotal function but this doesn't seem to work nested in sumproduct. Can anyone offer some advice?

Thanks!