Simpler formula?

[David Turner]

I currently use this to get a number of items to order:

=LEFT('Food Items'!I4,1)*COUNTIF('Food Items'!H4,">="&'Food Items'!G4)

It seems a bit convoluted to me and took me a while on Google to find the
(">=" &) solution. I stumbled on it quite by accident. Is there a better
way?

 

[Arvi Laanemets]

Hi

What about
=LEFT('Food Items'!I4,1)*('Food Items'!H4>='Food Items'!G4)

 

[David Turner]

Arvi Laanemets wrote

What about
=LEFT('Food Items'!I4,1)*('Food Items'!H4>='Food Items'!G4)

Yeah, that works. Thanks.