Hi all,
I have formula that's not working...
=COUNTIFS(A1:F5,"FARM A",A1:F5,"Orange")
return "0"
Required answer is 2
Please help...
I have formula that's not working...
=COUNTIFS(A1:F5,"FARM A",A1:F5,"Orange")
return "0"
Required answer is 2
Please help...
A | B | C | D | E | F | |
1 | STOR A | STOR B | STOR C | STOR D | STOR E | |
2 | FARM A | Orange | Avocados | Bananas | Cherry | Orange |
3 | FARM B | Grape | Cherry | Guava | Bananas | Bananas |
4 | FARM C | Orange | Bananas | Orange | Bananas | Avocados |
5 | FARM D | Grape | Guava | Grape | Guava | Cherry |