Hello Everyone,
I've been working on a file whose goal is transform quarterly revenues and costs into annual ones.
I've managed to do it thanks to INDIRECT and MATCH function but I wanted to try other (faster solutions):
1. I tried INDEX MATCH but I get a Value error (cf cell K4 of the spreadsheet)
2. I'd like to do it with SUMPRODUCT but do not where to begin with
Thanks a lot for your help !
PS: I'm not sure if I must create to separate posts since there are two questions, if so I will comply.
Bookmarks