Thread: How do I specify cell contents for the Criteria in SUMIF?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default How do I specify cell contents for the Criteria in SUMIF?
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

Reply With QuoteReply With Quote