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
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!
| A | B | C | |
| 1 | Fruit | Location | Day |
| 2 | Apple | Farm 1 | Monday |
| 3 | Apple | Farm 1 | Tuesday |
| 4 | Apple | Farm 2 | Tuesday |
| 5 | Apple | Farm 2 | Monday |
| 6 | Apple | Farm 1 | Monday |
| 7 | Apple | Farm 3 | Monday |
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.
---------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment