Define range ref in sumproduct

Wilson · Sep 1, 2003

Thanks - but I figured it out:

=SUMPRODUCT((C$5:INDIRECT("C"&"$"&COUNT(C$5:C$369))=O1)*...

Wil

J.E. McGimpsey · Sep 1, 2003

Another way:

=SUMPRODUCT((C$5:C$369<>"")*(C$5:C$369=O1)*...)

Formula Error When Sorting	1	Nov 7, 2011
Sumproduct giving #Value error	5	Jan 21, 2013
referencing a range in Sumproduct function	6	Sep 4, 2009
Global Change Of Formula Value	2	Oct 21, 2011
sumproduct with multiple variables	10	Nov 10, 2009
Formula I can't figure out	2	Nov 13, 2012
Count the remaining weekdays in a data range excluding holidays and start/end dates	5	Jul 23, 2013
Counting cells with SUMPRODUCT and conditionals...?	1	Oct 10, 2012

Ask a Question