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