M
ms3348
Hi
I have following sumproduct:
=SUMPRODUCT(($A$2:$A$9487="101")*($B$2:$B$9487="0")*($E$2:$E$9487=
{4;5;6})*$C$2:$C$9487)
My problem is that my sheet always starts at row #2 but the numbers of
rows change from time to time - so I need excel to count the numbers
of rows and automatically place it where 9487 is placed today.
Can someone help me?
Thank you ind advance
Mikael
I have following sumproduct:
=SUMPRODUCT(($A$2:$A$9487="101")*($B$2:$B$9487="0")*($E$2:$E$9487=
{4;5;6})*$C$2:$C$9487)
My problem is that my sheet always starts at row #2 but the numbers of
rows change from time to time - so I need excel to count the numbers
of rows and automatically place it where 9487 is placed today.
Can someone help me?
Thank you ind advance
Mikael