Counting names in multiple ranges

[windrain]

Hi All,

I am trying to total how many clients are listed on my spreadsheet. I can do a single range with no problem, however my names are separated by other information so I need to do multiple ranges. I have tried
quite a few different ways. The formula I left on my spreadsheet is =COUNTIFS(B17:G20,"=*",B25:G28,"=*",B33:G36,"=*"). It will only give a total of 3 and it should be 9.

I have attached an example spread sheet. The yellow box is where the formula is and the green boxes are what I need to count.

Thank you very much in advance for your help.

Stacey

[Tony Valko]

If you only have a "few" ranges you could do this:

=COUNTA(B17:G20)+COUNTA(B25:G28)+COUNTA(B33:G36)