SOLVED

Sum of products in filtered table (date)

Copper Contributor

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 :) Przechwytywanie.PNG

2 Replies
best response confirmed by Matt4670 (Copper Contributor)
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)))

 

@Hans Vogelaar,

Great ! It works !

Thank You
Matt4670

1 best response

Accepted Solutions
best response confirmed by Matt4670 (Copper Contributor)
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)))

 

View solution in original post