ExcelBanter - SUMIFS - How to use a variable with or

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIFS - How to use a variable with or < in criteria (https://www.excelbanter.com/excel-worksheet-functions/246998-sumifs-how-use-variable-criteria.html)

Jeff Lowenstein

SUMIFS - How to use a variable with or < in criteria

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

RagDyeR

SUMIFS - How to use a variable with or < in criteria

I don't use XL07, but I'd guess it's the same as Sumif(), so try:

=SUMIF(C1:C10,""&M3,D1:D10)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"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

Ashish Mathur[_2_]

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

All times are GMT +1. The time now is 02:32 PM.