| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif with two Criteria
I am using a Sumif formula to return the sum of values less than 50 in
column D which works fine except that I now need it to return less than 50 but greater than 15. Whist the below is an example only, the spreadsheet Book2 varies in range week over week which is why I have defined the range $D:$D. I have tried "15#AND#<50 in cell B3 but to no avail. Is there a way to achive this? Thanks, Rob =SUMIF([Book2]Sheet1!$D:$D,B3,[Book2]Sheet1!$D:$D) B3 contains the text "<50 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
| Multiple SUMIF Criteria | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Threaded Mode
