Counting Names in one column if the adjacent column contains a specific number

I want to total the amount of names in one column only if the cell in the adjacent column contains a specific number. Kind of like the sumif function but for words.
For example I'm looking for a formula that would tell me how many names contain the number "1" next to it.

1 -> John
1 -> Frank
1 -> Mary
2 -> Mr. Ed
3 -> Tony
1 -> Megan
3 -> Christa
3 -> Jacob

The formula should result in "4" which correlates to the amount of names that have the number 1 next to it. Please help me out. Eventually I want to utilize it in a google documents spreadsheet. Is there any reason it wouldn't work in google docs but will work in Excel? I have tried using any array formula but I'm not getting the results I'm looking for.

Thanks, it works great in Excel but for some reason not in google documents. I'm assuming google docs' spreadsheet isn't as intelligent as Excel is, is there a "dumber" formula I can use instead?

vlady, you're correct that the countif would work perfectly for this, but I only posted part my spread sheet. I have additional columns with names too, but won't necessarily be the same amount as the first column of names.

Invitee->Spouse
1 -> John -> Sally
1 -> Frank -> Patty
1 -> Mary
2 -> Mr. Ed -> Lois
3 -> Tony -> Joyce
1 -> Megan -> Bill
3 -> Christa -> Matt
3 -> Jacob

So I want to total the amount of invitees separate from the amount of spouses that have a 1 at the beginning of each row.
Invitees with 1 = "4"
Spouses with 1 = "3"

Originally Posted by Haseeb A

Not sure about google document, try this

=ARRAYFORMULA(SUMPRODUCT((A2:A10=1)*(B2:B10<>"")))

Still no luck. However instead of #value error message it returns a zero. Could be getting somewhere...