Simpler formula?

  • Thread starter Thread starter David Turner
  • Start date Start date
D

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?
 
Back
Top