SOLVED

# Sum of products in filtered table (date)

Copper Contributor

# Sum of products in filtered table (date)

Hi,

I have two columns of data that I want to multiply by each other and sum the resulting products.

The formula must work for the table filter used (date). That is, it sums the products of a given day.

2 Replies
best response confirmed by Matt4670 (Copper Contributor)
Solution

# Re: Sum of products in filtered table (date)

With a table named Table1:

=SUMPRODUCT(Table1[ILOŚĆ SZT],SUBTOTAL(9,OFFSET(Table1[CZAS PRACY],ROW(Table1[CZAS PRACY])-MIN(ROW(Table1[CZAS PRACY])),0,1)))

=SZORZATÖSSZEG(Table1[ILOŚĆ SZT];RÉSZÖSSZEG(9;ELTOLÁS(Table1[CZAS PRACY];SOR(Table1[CZAS PRACY])-MIN(SOR(Table1[CZAS PRACY]));0;1)))

# Re: Sum of products in filtered table (date)

@HansVogelaar,

Great ! It works !

Thank You
Matt4670

1 best response

Accepted Solutions
best response confirmed by Matt4670 (Copper Contributor)
Solution

# Re: Sum of products in filtered table (date)

With a table named Table1:

=SUMPRODUCT(Table1[ILOŚĆ SZT],SUBTOTAL(9,OFFSET(Table1[CZAS PRACY],ROW(Table1[CZAS PRACY])-MIN(ROW(Table1[CZAS PRACY])),0,1)))

=SZORZATÖSSZEG(Table1[ILOŚĆ SZT];RÉSZÖSSZEG(9;ELTOLÁS(Table1[CZAS PRACY];SOR(Table1[CZAS PRACY])-MIN(SOR(Table1[CZAS PRACY]));0;1)))