| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
| How do I automatically count the number of cells highlighted | Excel Discussion (Misc queries) | |||
| Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
| How do I automatically count the number of cells highlighted | Excel Discussion (Misc queries) | |||
| Using sumproduct to count number by date | Excel Worksheet Functions | |||
Threaded Mode
