Sum of products in filtered table (date)

[Matt4670]

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.

Please support me :) 

[#2 · Accepted solution]

@Matt4670 

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)))

[#3]

@HansVogelaar,

Great ! It works !

Thank You
Matt4670