How To Reference Another Sheet Tab Section Within a Function Equation For Google Sheets

The Formula To Reference Another Sheet Tab Section Within a Function / Equation For Google Sheets Is Done Like This:

I could not find anywhere, not even in Google's official page how to reference another sheet name and cell (s) within an equation for Google Sheets.

Through trial and error, this is what I found that works. Let's say the Google sheet tab you want to reference is named "Feb", and the function you use is Countif, which you want to search that sheet for the word Friday to determine how many Fridays you have on there that you did a certain task on, then here is the formula you would use:

=Countif (Feb!A1:Z100, "friday")

Now, in that cell, it will display the number.


No comments:

Post a Comment