| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIFS with an OR criteria | Excel Worksheet Functions | |||
| using sumifs with multiple criteria? | Excel Discussion (Misc queries) | |||
| sumifs criteria | Excel Worksheet Functions | |||
| SUMIFS with 3 criteria instead of just 2 | Excel Worksheet Functions | |||
| using sumifs to sum based on month, and criteria | Excel Worksheet Functions | |||
Linear Mode
