| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use month in cell date to sum all relevant cells
Hi - I have a Sheet of orders entered in rows, order date is col D and order quantities in columns O through AM (1 product per column, if not required cell is blank). On a different sheet I am trying to sum all the orders for each product / month
I have entered =SUMIF(MONTH('Sheet1'!$D$6:$D$1008),4,'Sheet1'!O$6 :O$1008) meaning if the month value in the cell is 4 (April) count any quantity in corresponding cell column O. What have I done wrong please? Thanks for looking |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Month and year from Cell containing date, month, year & time | Excel Worksheet Functions | |||
| Adding up relevant cells | Excel Discussion (Misc queries) | |||
| Formula for cells containing last month's date | Excel Discussion (Misc queries) | |||
| Remove cells with text not relevant | Excel Worksheet Functions | |||
| Calculate month-end date from date in adjacent cell? | Excel Worksheet Functions | |||
![Chris Smith[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
