Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF & MONTH() ?
Hi,
I have a spreadsheet that contains a list of dates in A column, text in B column, and amounts in C column (simple bookkeeping). On a different sheet in the workbook, I want to collect the totals by month (for budgeting). How can I setup a formula that will SUMIF by MONTH ? I just want it to scan the whole list and total the amounts for a given month but I can't 'seem to figure it out. Thank you, D |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
sumif date is in certain month | Excel Worksheet Functions | |||
Add one month to the previuos month | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions | |||
How to extract month number from month name | Excel Discussion (Misc queries) |