Quote:
Originally Posted by T. Valko
No problem! Use dynamic ranges. Assumes no empty cells *within* the ranges.
In Excel 2007...
Formulas tabDefined NamesName Manager
Click the New button
Name: Range1
Refers to:
=Sheet1!$H$3:INDEX(Sheet1!$H:$H,COUNT(Sheet1!$H:$H )+2)
--David [/i][/color]
|
Can the sumproduct be calculated on more than one column at a time?
For example,
=SUMPRODUCT(--(D$2:D$49=""),--(E$2:E$49="TEST"))
works great, but
=SUMPRODUCT(--(B$2:D$49=""),--(E$2:E$49="TEST"))
returns #VALUE