Looking for a formula that would measure across ranges. For example if I
wanted to caluculate how many time "US, BIG and Country" appeared together on
the same row, how would I do that.

A B C D
E
1 US BIG Country Country Town

2 CAN BIG Country City Village

3 AUS BIG City Country
Province

4 US BIG State Country Country

5 UK SMALL Province City Street

6 UK SMALL Country State Country

7 US SMALL City Country Town