I have a data range for invoices and need to total all the invoices by month. So the heading on the data are invoice #, description, Date, amount.
I need to take all the amounts in the month of november and get a total, and so on for all the months in the year. I only need a total amount for the month, but if theres a way to generate a list for all the months enteries that woudl be great too. I think a simple sumif may be possible, but cant think of a way to write out a sum if that would work.
Thanks in advance,
Esteban
Hi
you posted in a MSWord forum, is that correct?
In XL you could use a Pivot Table f.i.
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
sorry about that, can a mod move this to the correct section please.
Thread moved
Have you tried using a Pivot Table and grouping by month ?
( there are other possibilities - best to post a sample sheet)
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks