Thursday, January 2, 2014

yogi_Count Instances Of Specified Entities From The Last Specified Number Of Entries In Column A

                                          Google Spreadsheet   Post  #1467
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-02-2014
post by chessphi (http://productforums.google.com/forum/?zx=ftkkyxcf4zk8#!category-topic/docs/spreadsheets/FoRVcg_yZ7A)
Need spreadsheet function for last X entries in a column
Hi,

Somewhat new to spreadsheet functions and I happen to hardcode data that looks something like this:


A  B
--------
1  W
2   L
3  W
4   L
5  W
6   L
7  W
8   L
9   L
10 W

...and it continues on to about 100 rows or so.


I need to get two values on column B:
1) the number of W's in the last 5 entries, and
2) the number of L's in the last 5 entries


Thanks in advance!
------------------------------------------------------------------------------------------------------------------------------------------------