Forum Discussion
Solved
Sum of data across multiple columns & rows based on Criteria
I have a data set that ranges across multiple rows and columns. I am building a nested formula and looking to sum QTY based on multiple criteria in one part of it. I tried sumifs, however, that doe...
Try
=SUMPRODUCT('PROD&DMD'!$G$4:$AF$2099, ('PROD&DMD'!$A$4:$A$2099=$A4)*('PROD&DMD'!$G$2:$AF$2=$M4)
Try
=SUMPRODUCT('PROD&DMD'!$G$4:$AF$2099, ('PROD&DMD'!$A$4:$A$2099=$A4)*('PROD&DMD'!$G$2:$AF$2=$M4)
HansVogelaar This worked perfectly! Thank you!
- OMG I didn't think this was possible! you have saved me hours of changing my data structure - THANK YOU!
