I have an excel file with the following formula:
I understand that we are using the sumifs function to sum different cells according to certain conditions. Nevertheless, I get confused with the "!" operators, and the use of lower case letters and the "'" symbols.Please Login or Register to view this content.
I learnt about the SUMIFS function, the INDIRECT function, etc. but I can't work out the meaning of this.
Maybe someone could change this formula in a "human-mode" version?
I would much appreciate your assistance.
Bookmarks