Hi,

I'm having brain freeze here (maybe because it's 3 AM), but I'm trying to count how many rows with two different criteria. It' really the opposite of countifs. So in Column A let's say there are countries and in column B there are currencies. I want to know how many rows contain "USA" in column A OR "USD" in column B. If I wanted both then it could be:

Formula: copy to clipboard 
=Countifs(A:A,"USA",B:B,"USD")


Thanks.

abousetta