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)*...)