Calculate SUBTOTAL of a SUMPRODUCT within a filtered range

Hi,

I need to adjust my SUMPRODUCT formula to calculate only the filtered range as with SUBTOTAL. Workbook attached has 3 columns where the formula for "Manager" and "Officer" columns counts how many unique names appears in the column. When I filter the "Manager" column selecting Xxxxxx, the totals should update to "Manager" - 1, "Officer" - 5

Hi,

I found this formula at :

http://www.mrexcel.com/forum/excel-q...ed-column.html

Please Login or Register  to view this content.

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself


Hope this is helpful.

Cheers

Works great, thank you!!

Glad I could be of some assistance