Forum Discussion
Possibility to have a more practical formula
Dear All, thank you in advance for your support. I have this formula which, as you can see, refers to multiple sheets, is there a simpler way of how to get the results I need (Formula Below) =IF(D5...
AlbertM1960 Since the SUMIF seems to repeat based except for the sheet reference, maybe considered consolidating all the tables to one final sourced table. That way the SUMIF can then be updated to SUMIFS, taking into the account the new variable (ie. the month). If you can attach a sample workbook, removing any sensitive data, I can create a sample of what I mean.