Help with value error and external spreadsheet

[McKennshere]

I need help changing my countif to a sumif formula so that results are available when the worksheet is closed. My countif formula is simple and works fine when the sheet is open.

=COUNTIF('[DISTRICT G.xlsx]DIST G ALL'!$N:$N,">0")

I have tried:

=SUM(IF('H:\Cm\pi\ps\ddr\[DISTRICT G.xlsx]DIST G'!$N:$N=">0",1,0))

This shouldn't be this hard to do but all it returns is a 0, I am at whits end and.......my brain hurts.


Can anyone help?

 

[Scott T]

Non of the somethingIF functions work with a closed workbook try sumproduct.
Try

=SUMPRODUCT(--('H:\Cm\pi\ps\ddr\[DISTRICT G.xlsx]Sheet1'!$N:$N>0))