Subtotals

[JoboM]

Hi,

I have a filtered table that I was hoping have running subtotals on. I'd like the subtotal to count the number of extries in a filtered table that are greater than 0. Is this possible? I couldn't find anything similar in the SUBTOTAL() code.

Thanks, guys

 

[sheetspread]

See if sumproduct counts only the visible cells

 

[JoboM]

No, it counts all visible and invisible unfortunately

 

[sheetspread]

This work?

Count visible cells only for values greater than or equal to X


or:

http://www.mrexcel.com/forum/excel-questions/509428-sumif-countif-visible-cells-only.html