SUMIF that only works if the cell it's counting is a typed number and not a formula

[Tristram_ZX81]

I'm using Microsoft 365 MSO. I have a SUMIF that only works if the cell it's counting is a number I've typed in and not the result of a formula.

So Sheet 2 has this formula

=SUMIFS('Sheet1'!A6:A1000, 'Sheet1'!G6:G1000, ">=08:00:00", 'Sheet1'!G6:G1000, "<=11:00:00", 'Sheet1'!D6:D1000, "Thursday*")

The cells in A6:A1000 display the numbers resulting from this formula, applying a value depending on phrases.

=IF(ISNUMBER(SEARCH("apples",O17)),".1",IF(ISNUMBER(SEARCH("oranges",O17)),".1",IF(ISNUMBER(SEARCH("bananas",I17)),"0",IF(ISNUMBER(SEARCH("kiwis",I17)),"1",IF(ISNUMBER(SEARCH("pears",I17)),"1",IF(ISNUMBER(SEARCH("satsumas",I17)),".5",""))))))

For reasons I can't fathom, the SUMIF was working earlier. But now it just shows 0.0 or #VALUE!. Any ideas?

 

[Fluff]

Remove the quotes from your numbers, otherwise they are text & not numbers.

 

[Tristram_ZX81]

Remove the quotes from your numbers, otherwise they are text & not numbers.

That's worked. Thanks very much!

 

[Fluff]

You're welcome & thanks for the feedback.