Thursday, July 24, 2014

yogi_From Data In Table By Fruit Location And Day Count Fruit by Farm And Day of Week

                            Google Spreadsheet   Post  #1707
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-24-2014
post by 54612387:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/wC9dWyVZBrk)
Countif help
Trying to count some items, and need some help!

ABC
1FruitLocationDay
2AppleFarm 1Monday
3AppleFarm 1Tuesday
4AppleFarm 2Tuesday
5AppleFarm 2Monday
6AppleFarm 1Monday
7AppleFarm 3Monday

I am trying to create a formula that will tell me the number of occurrences of Apple: at each farm, and on each day of the week. For example, Apple at Farm 1 on Monday occurs twice. 
---------------------------------------------------------------------------------------------------------------------------------