[Hidden-tech] Looking for Google Sheets formula help

Michael Muller tech at montaguewebworks.com
Mon Nov 25 20:50:49 UTC 2024


Hey all,

I have a multi-tab Google Sheet that keeps stats on players in a game 
I'm helping manage. Looking to do some intra-sheet math to create an 
index of the players.

Essentially, TAB1, TAB2, TAB3 all have player names in a left column, 
and a score in the next column over that need to be combined, and posted 
to a matching player field in TAB4.

I already know how to do things like this:    =COUNTIF(Guild!A1:A82, 
"21")    but I need to grab one field from three tabs, based on matching 
player names in all four tabs.

Anyone has a minute and some expertise in this area?

Thanks,

Mik

-- 
Mik Muller, president
Montague WebWorks
20 River Street, Greenfield, MA
413-320-5336
http://MontagueWebWorks.com
Powered by ROCKETFUSION
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20241125/35cf8e29/attachment-0001.html>


Google

More information about the Hidden-discuss mailing list