Thread: SUMIFS - How to use a variable with or < in criteria
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default SUMIFS - How to use a variable with or < in criteria
Hi,

Try ""&M3

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jeff Lowenstein" wrote in
message ...
Hello,

I am having problems using the M3 as the criteria. What is the correct
syntax for using a cell reference in the criteria field of the SUMIFS?

Thank You

Reply With QuoteReply With Quote