Home » Forums » Open Source Learning Center » Question and Answer

Help needed with syntax

Submitted by AngelaW on 7 May, 2012 - 00:01

I need help with the syntex that will allow me to count the number of nonblank cells in one column that also have a "Y" in the next column. Here is what I have that is NOT working (it counts the BLANKS: =COUNTIFS(TRAINING!Q4:Q287,"",TRAINING!R4:R287,"y")
I need to count the people who have taken a training course (indicated by the date in the first colum) against those who are required (indicated by a "Y" in the second column) to take the course. Please help quickly! This project is due tomorrow!

Thank you so much!
Angela

‹ Matching cells loop without do - Sorry if this is a repeat of the ultimate noob question but... ›
»
Vishesh's picture

Try this

Submitted by Vishesh on 7 May, 2012 - 04:39.

=COUNTIFS(Training!Q4:Q287,"<>",Training!R4:R287,"Y")

»

ALMOST correct

Submitted by Anonymous on 10 May, 2012 - 20:32.

That was close but after hours of trying the correct is:
=COUNTIFS(TRAINING!Q2:Q287,"<>"&"",TRAINING!R4:R287,"y")

Thank you for your help. Now I have another problem!
I need to count all cells that have a date which is greater than two years from the current date. Can you help me with this? Also, is there a way to select those in a separate list or worksheet?

Thanks,
Angela

»