Forum Discussion
sumif horiztonally and vertically
how can i update my formula in the summary tab such that when i drag my formula down it finds the month and pulls in the correct column from the raw data tab.
ctone00 ,
see attached. All methods are pretty much using the same matrix multiplication logic. There are probably plenty more solutions to this.