Using Sumproduct+countif

[UndwaterExcelWeaver]

I have a formula that pulls from another spreadsheet to count cells of a certain criteria but the destination sheet must be open to return the value, otherwise I get a #value error. I have read that I should be using the sumproduct function to fix this but I can't quite decipher how this should be implemented. Here is the current formula:

=COUNTIF('[external sheet]18'!$Q$8:$Q$31,72000)+COUNTIF('[external sheet]18'!$Q$8:$Q$31,36000)

Thank you.

 

[Fluff]

How about

=sumproduct(('[external sheet]18'!$Q$8:$Q$31=72000)+('[external sheet]18'!$Q$8:$Q$31=36000))

 

[UndwaterExcelWeaver]

How about

=sumproduct(('[external sheet]18'!$Q$8:$Q$31=72000)+('[external sheet]18'!$Q$8:$Q$31=36000))

Thank you. That worked.

 

[Fluff]

You're welcome & thanks for the feedback.