I have to populate a spreadsheet with a similar layout to the attached example.
In the attached example I need to populate sheet 2 with the data from sheet 1. The 'name' determines which row the data appears in, the month under 'date' determines which column the data appears in and the 'value' is the data required.
The actual task has thousands of lines of data and spans over many years, so manually inputting the data isn't an option.
Can anyone help with a formula?
Last edited by MjRmatt; 07-30-2010 at 07:42 AM.
I believe the answer is along the lines of =SUMIFS(Sheet1!F2:F17,Sheet1!A2:A17,"mm"={1},Sheet1!G2:G17,"Mr. A") for Sheet 2, B3... but this returns a 0 value?
Hi Mj,
no file attached - Edit your original post - Click Go Advanced and click the " manage attachments" button
My bad, now attached
Using SUMIFS (as you should XL2007+) either
or
Please Login or Register to view this content.
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks