Forum Discussion
Excel Formula
I am trying to write a formula that will add up a symbol (in my case an x) that is in the same cell over several sheets in the same workbook and enter the total on an another sheet. For example: she...
Hi James,
This can be done using this formula:
=SUMPRODUCT(COUNTIF(INDIRECT("'"&{"Sheet1";"Sheet2";"Sheet3";"Sheet4"}&"'!D5"),"x"))
I got it from https://www.extendoffice.com/documents/excel/2541-excel-countif-across-multiple-worksheets.html.