SquirrelGuirrel
New Member
- Joined
- Feb 26, 2002
- Messages
- 10
HI there,
I am trying to count the number of times 2 criteria are met. The loan month must be Jan and the year must be 2002. If both criteria are not meant I would like a zero value returned. I am using the following formula and getting a VALUE error
=COUNTIF(G2:G59,"JAN")*AND(H2:H59,"2002"),"0")
Do the Date and month need to be formatted as text?
I searched the old posts but couldn't find any countif with an else scenario. Thanks for your help
I am trying to count the number of times 2 criteria are met. The loan month must be Jan and the year must be 2002. If both criteria are not meant I would like a zero value returned. I am using the following formula and getting a VALUE error
=COUNTIF(G2:G59,"JAN")*AND(H2:H59,"2002"),"0")
Do the Date and month need to be formatted as text?
I searched the old posts but couldn't find any countif with an else scenario. Thanks for your help