View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] ms3348@gmail.com is offline
external usenet poster
 
Posts: 2
Default Sumproduct automatically count number of rows

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