"Rick Rothstein (MVP - VB)" wrote:

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.

Concatenate the "" with the contents of $D$3...

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

Rick


Super! Thanks!!!!