Hello All,
I am stuck on a formula for the spreadsheet attached.
On 'sheet 2' I have a drop down menu which selects an item and then calculates figures for that year. Unfortunately I currently have it set to lookup the figures for the 'Thing1'. I need the formula to look at each 'thing' and do the calculations for that. Hopefully the spreadsheet will make sense.
I'm not sure if I need a Vlookup or what.
So you want to eliminate the dropdown menu and do all calcs for all things?
If so, you probably would need a table of results for each "thing" on Sheet2.
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.
I don't want to eliminate the drop down menu, I just want it to do the calcs when I do select a 'thing' from the menu.
Right now if I select say, 'thing4', its still doing the calcs for 'thing1'. Not sure how I make it do the calcs for each thing when selected.
What are the intentions you had with this part of the formula?
SUMIF(Sheet1!$G45:$Q45,"Y",Sheet1!$G$25:$Q$25)
Should be checking if its a 'y' and if so taking the average and displaying as a percentage. I think, its someone else's formula, I just know that's what they have sent me.
checking a "y" where?
That formula looks like it is trying to sum all the numbers in the top table where the bottom table has a corresponding "y"... which doesn't make sense... and especially, the table sizes are not the same.
Are the percentages in your results table correct for "thing1"?
Can you explain, in words, what exactly you want the formula to do?
Sorry, as I say the spreadsheet was sent to me by someone and I've been
asked to populate the existing table with the formula provided by
selecting from the dropdown menu and it calculating for each 'thing'
right now the formula is just stuck to look at the data for 'Thing1' for
all other 'things'.
I know the table sizes dont match, the dates on 'sheet 2' start midway
down the table on 'sheet 1'.
Try:
copied down and across the matrix.
Please Login or Register to view this content.
Note: I just changed one thing in the formula above.. make sure you use the formula that is there now... (i.e. after this posting).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks