Summing Problem

[The doomed]

I have the following calc:

=SUMPRODUCT(--(ISNUMBER(SEARCH($F$2,'Closed Projects'!$BH$4:$BH$9824))),--(ISNUMBER(SEARCH(1,'Closed Projects'!$BK$4:$BK$9824))))

Is there any quick and easy way to change the last bit so it only counts where the cells in col BK are not equal to 1?

All cells in BK are formatted as %ages.

 

[texasalynn]

I have the following calc:

=SUMPRODUCT(--(ISNUMBER(SEARCH($F$2,'Closed Projects'!$BH$4:$BH$9824))),--(ISNUMBER(SEARCH(1,'Closed Projects'!$BK$4:$BK$9824))))

Is there any quick and easy way to change the last bit so it only counts where the cells in col BK are not equal to 1?

All cells in BK are formatted as %ages.

=SUMPRODUCT(--(ISNUMBER(SEARCH($F$2,'Closed Projects'!$BH$4:$BH$9824))),--(ISNUMBER(SEARCH(1,'Closed Projects'!$BK$4:$BK$9824))),--('Closed Projects'!$BK$4:$BK$9824<>1))/code]

HTH

 

[The doomed]

=SUMPRODUCT(--(ISNUMBER(SEARCH($F$2,'Closed Projects'!$BH$4:$BH$9824))),--(ISNUMBER(SEARCH(1,'Closed Projects'!$BK$4:$BK$9824))),--('Closed Projects'!$BK$4:$BK$9824<>1))/code]
 
HTH[/quote]
 
 
doh, thank you! :)