Counting the Dates in one column if the value in another column is "X".

[CharHRussell]

I've tried every formula I could find online and in Excel help. I have a spreadsheet with many columns. Column B contains business tracks; QTD, ATM, PLM, etc. Column I contains the dates new items where added to the spreadsheet for each business track. Their may be as many items listed for QTD. I only want to count the number of dates listed in Column I that have QTD in column B, etc. for ATM, PLM and all other business tracks. I'm doing it on a separate summary worksheet where I have Dashboards.

 

[Joe4]

OK, if they both returned TRUE, then the formula I gave you at the top of my previous post (in the "code" box) shouldn't return zero, as there is at least one row in there that meets both criteria.
Can you confirm that?

 

[CharHRussell]

Okay,
=UPKs!B8="QTD" returned TRUE
=UPKs!I8>0 returned FALSE

Not really. I added the second formula but dind't have a date in I8 at the time so when it returned a FALSE, I was technically correct. Once I put a date in I8, it returned TRUE. So it appears that both of these formulas work as written.

 

[CharHRussell]

Okay, I missed placing the code in. I just tried the bottom two pieces of formula. The formula you sent in the Code: box works perfectly. My apologies for not being more thorough in reading your comments. Thank you for helping and fixing my problem!

 

[Joe4]

You are welcome.