Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I sum cells for a certain month?
Hello,
I am using this formula =SUMPRODUCT(--(MONTH(Gateway!B3:B26)=1),--(YEAR(Gateway!B3:B26)=2005),--(ISNUMBER(Gateway!B3:B26)))which works fine. Based on this formula how can I sum the dollar value in column J for the month of January? Your help is appreciated. Mark |
#2
|
|||
|
|||
I might be misunderstanding, but if you want to get totals by month the best
way might be a pivot table. Selecting all data in the sheet (including column headers), go to data-pivot table and follow the wizard, (next, next, finish). Then drag the date column heading from the pivot table field list to the row fields area and the money column heading from the pivot table field list to the data items area. If you right-click on the date column heading on the pivot table, you can choose to group them by month and year. "Mark Jackson" wrote: Hello, I am using this formula =SUMPRODUCT(--(MONTH(Gateway!B3:B26)=1),--(YEAR(Gateway!B3:B26)=2005),--(ISNUMBER(Gateway!B3:B26)))which works fine. Based on this formula how can I sum the dollar value in column J for the month of January? Your help is appreciated. Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |