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   Jul-24-2014
post by 54612387:
Countif help
Trying to count some items, and need some help!

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.