LinkBack URL
About LinkBacks
See attached spreadsheet. I am trying to create one formula that will take the product of numbers in column B based on criteria in column A (want the product of %s in each year). Product if formula.xlsx
Thanks for your help!
See attached spreadsheet. I am trying to create one formula that will take the product of numbers in column B based on criteria in column A (want the product of %s in each year). Product if formula.xlsx
Thanks for your help!
Try this in D1:
=SUMIF(A:A,2011,B:B)
Add this into different cells for each year. Format the cells as percentages.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you for your reply, but I need the product of the %s not the sum.
Hi kris10s7,
All you have on your spreadsheet is Year and Percentages. What exactly you mean by Product is unclear. At least provide with the expected results.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
The answers are below. So for 2011, the calculation is 105.88%*98.99%*95.48%**94.82%*88.25%*100.83%*106.76%*94.79%*102.87%. I have multiple spreadsheets of data with different start dates. I could use the product function, but then I would have to manually update the ranges for each spreadsheet. I would like to use a formula that would eliminate that problem.
2011 87.9%
2012 113.8%
2013 154.1%
Please see attached file with formulas
Formula in D3 is to get unique year criteria
Formula in E3 is to get desired result ***an array formula must be entered with Ctrl+Shift+Enter key combination.
This is perfect. Thanks so much.
You're welcome and thank you for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks