ExcelBanter - SUMPRODUCT help with filter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUMPRODUCT help with filter (https://www.excelbanter.com/excel-discussion-misc-queries/254798-sumproduct-help-filter.html)

Sam.D

SUMPRODUCT help with filter

I'm currently using the formula

=SUMPRODUCT((F2:I1475=1)*(F2:I1475<=9999))

This gives me the number in the full range but I need this to update when I
put differnet filters on.

I've tried different things with SUBTOTAL but can't get it to work

Any help is greatly appreciated

Sam.D

מיכאל (מיקי) אבידן

SUMPRODUCT help with filter

SUBTOTAL with the function_num = 3 should count.
After applying the filter - Try:
=SUBTOTAL(3, F2:F1475)
Micky

"Sam.D" wrote:

I'm currently using the formula

=SUMPRODUCT((F2:I1475=1)*(F2:I1475<=9999))

This gives me the number in the full range but I need this to update when I
put differnet filters on.

I've tried different things with SUBTOTAL but can't get it to work

Any help is greatly appreciated

Sam.D

All times are GMT +1. The time now is 06:50 PM.