Is there a formula that allows to count rows from different sheets for one total?

Wen H.

My team usually builds calculation sheets with formulas referencing other sheets for dashboards. We need to show a total for the year adding current data plus archive which are 2 different sheets but, on a row-by-row basis.

Ryan Sides

Hi @Wen H.

Yes! Just combine your CountIfs with a plus sign + like this...

=COUNTIFS({Sheet 1 Range}, FIND(Model@row, @cell) > 0) + COUNTIFS({Sheet 2 Range}, FIND(Model@row, @cell) > 0) + COUNTIFS({Sheet 3 Range}, FIND(Model@row, @cell) > 0)

Does that help?

-Ryan

Ryan Sides

Hi @Wen H.

Yes! Just combine your CountIfs with a plus sign + like this...

=COUNTIFS({Sheet 1 Range}, FIND(Model@row, @cell) > 0) + COUNTIFS({Sheet 2 Range}, FIND(Model@row, @cell) > 0) + COUNTIFS({Sheet 3 Range}, FIND(Model@row, @cell) > 0)

Does that help?

-Ryan

Wen H.

Thank you so much!