mysticeyes
New Member
- Joined
- Mar 17, 2004
- Messages
- 2
Hi ~~~
I am trying to write a combination IF statement. What I need it to do is
If the month is January and your name is Joe Dirt count 1
(on this example it would be 3)
A B C
Date Name Manager
2/1/2003 Joe Dirt Jones
1/2/2003 Joe Dirt Martinez
2/3/2003 Joe Dirt Jones
1/2/2003 Joe Dirt Jones
1/1/2003 Joe Dirt Martinez
How would you put that a formula?
Any help would be GREATLY appriciated!!!! thax
I am trying to write a combination IF statement. What I need it to do is
If the month is January and your name is Joe Dirt count 1
(on this example it would be 3)
A B C
Date Name Manager
2/1/2003 Joe Dirt Jones
1/2/2003 Joe Dirt Martinez
2/3/2003 Joe Dirt Jones
1/2/2003 Joe Dirt Jones
1/1/2003 Joe Dirt Martinez
How would you put that a formula?
Any help would be GREATLY appriciated!!!! thax