Help me make a complex COUNTIF formula?

[Jyggalag]

hi all,

i have this setup:

I want to count every cell that has a numeric value for Zimbabwe, USA and the UK

How do I do that? I want it to discard the other cells such as "N/A", "-" or blank cells and only count the numeric ones with values and then return to me the number of cells containing a value for each country

thanks!))

 

[Fluff]

Duplicate to:help with super complex formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.