AgTalk Home
AgTalk Home
Search Forums | Classifieds (14) | Skins | Language
You are logged in as a guest. ( logon | register )

Google sheets users... Need help
View previous thread :: View next thread
   Forums List -> Stock TalkMessage format
 
tjdub
Posted 3/9/2019 13:32 (#7369489 - in reply to #7369113)
Subject: RE: Google sheets users... Need help



Here's a sample sheet I made a while ago:

https://docs.google.com/spreadsheets/d/1Imd_9BUVNjl9OIELJXEvbJwWu5L1...

On the "stats" tab there's equations for counting number of heifers and number of bulls.

The equation for counting heifers in the column this is example is:

=LEN(CONCATENATE(calves!G2:G)) - LEN(SUBSTITUTE(UPPER(CONCATENATE(calves!G2:G)), "H", ""))

Then you would do the same for the letter "B" and then once those are calculated, you would just use the calculated values that get put in these cells to find percentages.
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)