montanaaggie
Board Regular
- Joined
- Nov 11, 2005
- Messages
- 122
- Office Version
- 365
- Platform
- Windows
I am trying to do a COUNTIF with a range of cells. I keep getting the error "#VALUE!"
Here is my equation:
=COUNTIF((G16:G23,G25:G34,G36:G40,G42:G45,G47:G48,G50:G53,G55:G57,G59:G62),"Policy")
How should my equation look, so that it will look in those cells referenced and count the number of times a cell is populated with "Policy"
Thanks
Here is my equation:
=COUNTIF((G16:G23,G25:G34,G36:G40,G42:G45,G47:G48,G50:G53,G55:G57,G59:G62),"Policy")
How should my equation look, so that it will look in those cells referenced and count the number of times a cell is populated with "Policy"
Thanks