| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf: use of greater or less than operators in Criteria
Why can't the SumIf formula accept logical operators within the Criteria field?
I am trying to have the formula sum up all cost items in the sheet for which the associated date in another column is less than or equal to a threshhold date, for example: =SUMIF(D13:D62,<=K1,H13:H62) where K1 was the cell address containing the threshhold date. Apparently the SumIf formula in Excel is restricted to use with Criteria that have to be an exact match rather than a range, and its usefulness is dramatically reduced by this unnecessary restriction. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
| 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
