SUMIFS - what am I missing

[grahamcatto]

Hi,

I am trying to setup a model where the forecast number of days used in analysing the data from our ERP has to be lesser than the number entered in cell I1.

When I hardcode the number into the formula everything works OK,

However when I point the formula to cell I1 I get 0 as the answer for all calculations (I must have the syntax wrong!)

The formula is used in a number of different columns and over several thousand rows. The model is being used to make up for the inadequacies of our ERP by generating the data in the format that our Logistics and Sales Teams require.

Thanks for your assistance

Cheers

Graham

 

[Eric W]

Instead of

,"<$I$1")

try

,"<"&$I$1)

 

[grahamcatto]

Instead of

,"<$I$1")

try

,"<"&$I$1)

Thanks Eric, I always seem to get caught out with these type of formula. It all works great now.

 

[Eric W]

Happy to help!

 

[Peter_SSs]

Thanks Eric, I always seem to get caught out with these type of formula. It all works great now.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.