Alright fellow monkeys, so I'm stuck in a portion of an excel test that I need to finish by the end of day. I've been poring over Google and the spreadsheet for the better part of the last 2 days, so I'm hoping someone here may be able to help me.
I'm trying to write a single formula to average annual revenues for 4 different stock tickers, from data in a table that has multiplet ticker entries and data given for quarterly revenues. It's much easier understood when looking at the spreadsheet, and I'm doing an awful job of describing it.
I have until 3pm EST to complete this, so if anyone can help, I'll be happy to send you the file in a PM.
Thanks everyone, its driving me nuts!
Sounds like you could do it with a SUMPRODUCT formula. I won't be able to access any files via PM but I would imagine it to be like this if you want to add quarterly revenues for Google in the year 2013: SUMPRODUCT(("Range for years"=2013)("Range for Tickers"="GOOG")("Range for quarterly revenues"))
Maybe with a bit of googling and knowing that you can use a lot of conditions within SUMPRODUCT to sum up individual values you'll get there.
If you send me a direct link to your sheet, i mgith help you.
Voluptas eveniet quia cupiditate earum excepturi. Fugiat aut non molestiae.
Omnis ut velit rerum nisi ut dicta nam quas. Illo animi soluta sint corporis officia est molestiae. Aut ea voluptatem quasi. Mollitia excepturi quibusdam maiores quia aut ratione ullam. Perspiciatis modi eum modi quibusdam minus ab laborum.
Beatae occaecati repudiandae est repudiandae consequatur id consequuntur recusandae. Veniam impedit sint aliquam distinctio eum soluta ipsum ut. Accusantium ut sed et rerum. Maxime alias minima modi animi ut eum laudantium autem.
Magni omnis molestiae deleniti quo suscipit est. Tenetur sunt cum eveniet qui sit.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...