Make summary of specific data

Joesw775 

With LET and UNIQUE this formula seems to work in my Excel online sheet. Duplicates other than China and Germany are counted only once. The formula can be adapted if you want to count other countries regardless of duplicates.

=LET(arr,G3:G53,
unique,UNIQUE(arr),
SUM((unique<>N18)*(unique<>N19)*(NOT(ISBLANK(unique))))
)

Without Office365 or 2021 or Excel online this works in my sheet:

=SUM(MMULT((G3:G53<>N18)*(G3:G53<>N19)*(NOT(ISBLANK(G3:G53))),ROW(1:1)^0))

However this formula only counts the total number of occurances of other countries regardless of duplicates.

In both examples i applied following formulas for number of occurances of China and Germany. Enter these formulas with ctrl+shift+enter if you don't work with Office365 or 2021 or Excel online.

=SUM(N($G$3:$G$53=N18))

=SUM(N($G$3:$G$53=N19))