As per my previous reply:

=SUMIF($N$8:$N$288,"" & $D$3,$D$8:$D$288)


"Michael" wrote:



"Michael" wrote:

I am trying to use the cell contents as the Criteria specification as opposed
to a fixed text operator and cannot seem to figure out how to do it or if it
can be done.

I am getting an error with the following when trying to do a logical operator:
=SUMIF($N$8:$N$288,"$D$3",$D$8:$D$288)
I have tried it with and without the quotes and still get an error message.