JasonTruman
Board Regular
- Joined
- Sep 30, 2003
- Messages
- 85
Hi all
Anyone help (keeping it simple)
If I have a list of years in column A say lots of 2006, 2007 and 2008, then in column B, text, such as Backlog, No Backlog, is there a way using Countif to say how many are 2007 AND Backlog. I can do it using an IF combined AND in column C first to get a Yes and then count those up, but is there a way without having to do loads of calcs
Unless Countif isn't the way to go and there is another solution
Cheers
Anyone help (keeping it simple)
If I have a list of years in column A say lots of 2006, 2007 and 2008, then in column B, text, such as Backlog, No Backlog, is there a way using Countif to say how many are 2007 AND Backlog. I can do it using an IF combined AND in column C first to get a Yes and then count those up, but is there a way without having to do loads of calcs
Unless Countif isn't the way to go and there is another solution
Cheers