I have a excel 2007 spreadsheet which looks like this
Date Total
01-Nov £30.00
03-Nov £40.00
12-Nov £25.00
14-Dec £10.00
17-Dec £12.00
I am trying to total up by monthly i have been trying to the following formula
SUMIFS(G3:G7,Month(E3:E7),11)
I am getting an error with the above formula
The results I am trying to achieve
Nov £95
Dec £22
Any idea how i can achieve this am i using the correct formula if so what is wrong with it.
All help welcome.
Mo
Last edited by Mo2783; 06-17-2008 at 07:28 AM.
Hi,
You may try pivot table.
I tried the pivot table but i need to have more control of the data, so thats not an option.
i have noticed the date is serial_number so i need to convert that somehow to a proper date and then compare.
Try:
=SUMPRODUCT(--(Month(E3:E7)=11),G3:G7)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
It's really a good idea , i got it !thanks
Thanks guys for your help. Much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks