Forum Discussion
jordanbrown
Feb 18, 2023Copper Contributor
Looking for Formula help please!
Looking for assistance with a formula I had working great but it will not carry over onto multiple sheets. Two different formulas require the same multi-sheet function to work. I have essent...
SergeiBaklan
Feb 18, 2023Diamond Contributor
Depends on which Excel you are. If on latest 265 that could be done easier, otherwise idea is here https://exceljet.net/formulas/sum-across-multiple-worksheets-with-criteria
- jordanbrownFeb 18, 2023Copper Contributor
2019 Pro plus. Your link makes some sense but still not working right. Now I'm trying to figure out name ranging sheets. SergeiBaklan
- jordanbrownFeb 18, 2023Copper Contributor=SUMPRODUCT(SUMIF(INDIRECT(" ' " &1:31& " ' ! " & "a3:a52"),D13,INDIRECT(" ' " &1:31& " ' ! " & "e3:f52")))