How to get count of rows from another tab to summary tab in excel-CodePudding

Excel (2021 version/google spreadsheet)

I am trying to grab count of non-blank/non-zero rows from 20 different tabs in excel and display the count in summary tab. The header of my summary tab looks like below:

I am using =COUNTIF(G2:G22,"<>"&"No"&"") but this is working only in the current sheet. How do I use this in summary sheet?

What would be the best way to achieve this?

CodePudding user response：

Have you tried to use the ISBLANK(value) operation? Where the value is the reference to the cell that will be checked for emptiness.

Reference: https://support.google.com/docs/answer/3093290?hl=en#:~:text=ISBLANK returns TRUE if value,or a reference to data.

CodePudding user response：

I was able to resolve this by just putting the tab name. =COUNTIF('CustomerServices'!G2:G22,"<>"&"No"&"")