Count number of blanks in a row based on first column

Hello,

I have a sheet tracking data about how many trainings have been delivered to clients (attached). Each cell can (1) have a date the training was completed, (2) have N/A if the training won't be necessary for that client, or (3) remain blank because the training hasn't been delivered yet.

What I want is to count the number of blank cells in each row in another sheet ("Summary" worksheet in the attached file), with the following stipulations:

• Don't add an extra column in the TrainingData worksheet
• The data might be sorted differently sometimes, so I can't rely on Company 1 always being in column B.

I can do it without either one those stipulations, but I'm running into trouble when I take them both into account.

And just to be extra clear, the desired results are in Summary!B2:B5 show 0,3,4,5.

Thanks!

In B2 copied down:

=SUMPRODUCT((TrainingData!$A$2:$A$5=A2)*(TrainingData!$B$2:$F$5=""))

Glad to have helped.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.