What formula can I use to count the following? In Column C3 I have values XL, SM, CDV 14', CDV 16'
I need the formula in Column D3 to count the Values in Column H based on the vales that are in Column G.
I have it added manually now to show what it should add up to. Column D3 has a value of 42, this is based on that there are 42 "YES" in column G, anything but a "YES" does not get counted. I need this for each criteria in Column C
Thanks for the help
I need the formula in Column D3 to count the Values in Column H based on the vales that are in Column G.
I have it added manually now to show what it should add up to. Column D3 has a value of 42, this is based on that there are 42 "YES" in column G, anything but a "YES" does not get counted. I need this for each criteria in Column C
Thanks for the help
| Book5 | ||||||||
|---|---|---|---|---|---|---|---|---|
| C | D | E | F | G | H | |||
| 3 | XL | 42 | YES | XL | ||||
| 4 | SM | 1 | YES | XL | ||||
| 5 | CDV 14' | 2 | OOS | XL | ||||
| 6 | CDV 16' | 1 | YES | XL | ||||
| 7 | YES | XL | ||||||
| 8 | YES | XL | ||||||
| 9 | YES | XL | ||||||
| 10 | YES | XL | ||||||
| 11 | YES | XL | ||||||
| 12 | YES | XL | ||||||
| 13 | YES | XL | ||||||
| 14 | YES | XL | ||||||
| 15 | YES | XL | ||||||
| 16 | YES | XL | ||||||
| 17 | OOS | XL | ||||||
| 18 | YES | XL | ||||||
| 19 | YES | XL | ||||||
| 20 | YES | XL | ||||||
| 21 | YES | XL | ||||||
| 22 | YES | XL | ||||||
| 23 | YES | XL | ||||||
| 24 | YES | CDV 14' | ||||||
| 25 | YES | XL | ||||||
| 26 | YES | XL | ||||||
| 27 | YES | CDV 14' | ||||||
| 28 | YES | XL | ||||||
| 29 | OOS | XL | ||||||
| 30 | YES | XL | ||||||
| 31 | YES | XL | ||||||
| 32 | YES | XL | ||||||
| 33 | YES | XL | ||||||
| 34 | OOS | XL | ||||||
| 35 | YES | XL | ||||||
| 36 | YES | XL | ||||||
| 37 | YES | XL | ||||||
| 38 | YES | CDV 16' | ||||||
| 39 | YES | XL | ||||||
| 40 | YES | XL | ||||||
| 41 | YES | XL | ||||||
| 42 | YES | Small | ||||||
| 43 | Empty | XL | ||||||
| 44 | YES | XL | ||||||
| 45 | YES | XL | ||||||
| 46 | YES | XL | ||||||
| 47 | YES | XL | ||||||
| 48 | YES | XL | ||||||
| 49 | YES | XL | ||||||
| 50 | YES | XL | ||||||
| 51 | YES | XL | ||||||
| 52 | YES | XL | ||||||
| 53 | YES | XL | ||||||
Sheet1 | ||||||||
