Hi there, i need a hand please
See attached sample data.
I have a list of coded cost cells (worksheet EXP) which i need to consolidate into monthly totals (worksheet Totals)
I need the corresponding code costs(sheet EXP, Col G and H) to add together according to date (sheet EXP Col F) and show in the correct monthly expenditure column on the totals sheet.
I've been chipping away at this for a while but I'm not really getting anywhere so any help would be much appreciated.
Thanks.
Sample EXP.xls
Good morning.
One way is using SUMPRODUCT. First you have to modify the format of row 1 of Totals Sheet to date.
Then in B2 and copy down and across, use this formula.
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
That works well, thanks you very much, this forum is so helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks