Counting only cells in a row that have data in them.

[jgwade99]

I have two seperate training columns (IA & PII) and I have inserted the dates that the users have completed each training class. I am trying to count the number of users who have completed both of the training courses. I would like to be able to count the entire range, e3:f22 to determine the total number of users who have completed both courses, however if I have to do it row by row and then total it up at the bottom that is fine too. I have tried many formula's including the following one, but they do not work:

=COUNTIF(D2:D51,"*")

I have attached a copy of the spreadsheet.

Any help you can provide will be greatly appreciated.

v/r
Greg

[arthurbr]

Does this help =SUMPRODUCT((E3:E22<>"")*(F3:F22<>"")) ?

[davesexcel]

Try
=COUNTA(E3:F22)-COUNTA(B3:B22)

[jgwade99]

Arthurbr,

Your formula worked great. Can you please explain exactly what it all means and what it's doing. As you can tell, I'm not familiar with all the special characters and things. Also, how would I tally up each column individually?

[arthurbr]

There is a very good explanation of SUMPRODUCT at this site