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.
Culpa illo eveniet culpa beatae odio quos reiciendis. Veritatis laboriosam aliquam illum. Veniam enim maiores autem dolor ullam illum quia. Provident in itaque voluptatem nemo reprehenderit qui nostrum. Voluptates ullam voluptatem asperiores.
Magni ut ducimus quisquam aut. Esse ut et dolor iusto modi consequuntur quibusdam. Id labore vero quisquam eveniet. Voluptas ipsum quis sunt. Quae quo et excepturi.
Dignissimos nostrum doloribus dignissimos voluptate fugit ab. Dolore autem nostrum et et dolor error. Accusantium culpa et totam eum. A voluptates optio quos sunt. Ab autem ducimus impedit occaecati similique et eos. Nostrum cumque quia placeat expedita.
Voluptatum aut optio dignissimos nisi ut a. Aspernatur sequi est sunt.
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...