Sumproduct issue

[Steved]

Hello from Steved

=SUMPRODUCT(('All Bus Models'!$B$5:$B$2001="PANMURE DEPOT")*('All Bus Models'!$E$5:$E$2001="17.223"))

In All Bus Models spreadsheet I have 17.223.

If I change 17.223 to 17-223 in In All Bus Models spreadsheet it works.

Please what do I need to do to formula so that it will run 17.223

Thankyou.

[Paul]

Have you tried removing the quotes around "17.223"? Normally when you're looking for a number in a formula, you don't use quotes.

Unless the number happens to be formatted as text, in which case change your SUMPRODUCT formula to this:

Please Login or Register  to view this content.

If these suggestions don't work, let us know what you're trying to do, exactly, and we can probably assist.

[Steved]

Hello from Steved

Thankyou very much, I should have known better, the quotation marks did'nt register on my mind, which makes sense if they are not their.

Once again Thankyou.

Have you tried removing the quotes around "17.223"? Normally when you're looking for a number in a formula, you don't use quotes.

Unless the number happens to be formatted as text, in which case change your SUMPRODUCT formula to this:

Please Login or Register  to view this content.

If these suggestions don't work, let us know what you're trying to do, exactly, and we can probably assist.