Forum Discussion

Copper Contributor

Sep 08, 2021

Solved

Calculator Project

Hi All, Would really appreciate some help with this little project i have. I'm basically trying to create a calculator for a video game, that they can enter their current level, and the level...

Sample Calc.xlsx10 KB

excel

Formulas and Functions

office 365

Riny_van_Eekelen
Sep 08, 2021
WoodyBRUH Try this than:
=SUMIFS(D2:D6,A2:A6,">"&I5-1,A2:A6,"<="&J5-1)

HansVogelaar

MVP

Sep 08, 2021

WoodyBRUH

Try

=SUMIFS(D2:D6,A2:A6,">"&H5,A2:A6,"<="&I5)

WoodyBRUH
Copper Contributor
Sep 08, 2021
Hi,

Its extremely close, the result for the sample should be 27 but its outputting 30 for some reason?

I think its adding the difference between the 2 inputs making it output the incorrect value, if theres any way to stop that?
- Riny_van_Eekelen
  Platinum Contributor
  Sep 08, 2021
  WoodyBRUH Try this than:
  =SUMIFS(D2:D6,A2:A6,">"&I5-1,A2:A6,"<="&J5-1)
  - WoodyBRUH
    Copper Contributor
    Sep 08, 2021
    yep thats done it, appreciate it!