| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modify SUMIF to find data range in addition to value
I am using Excel 2007. How can I modify sumif formula to sum only cells that
meet the sumif and date range critiera? =SUMIF('1563'!$F$9:$G$55202,"groceries",'1563'!$D$ 9:$D$55202) -btw, it is near impossible to search the discussion group right now to find recent postings. And the nofication of replies is not working as well in the discussion groups. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find %ontime & SUMIF ontime ie: find matching sets within Range... | Excel Worksheet Functions | |||
| sumif range to end of data | Excel Discussion (Misc queries) | |||
| Modify SumIF... Array Formula | Excel Worksheet Functions | |||
| Modify SumIF... Array Formula | Excel Worksheet Functions | |||
| Modify SUMIF and COUNTIF to work with SUBTOTALS | Excel Worksheet Functions | |||
Threaded Mode
