SOLVED

Calculator Project

%3CLINGO-SUB%20id%3D%22lingo-sub-2732509%22%20slang%3D%22en-US%22%3ECalculator%20Project%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2732509%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20really%20appreciate%20some%20help%20with%20this%20little%20project%20i%20have.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20basically%20trying%20to%20create%20a%20calculator%20for%20a%20video%20game%2C%20that%20they%20can%20enter%20their%20current%20level%2C%20and%20the%20level%20they%20want%20to%20get%20to%2C%20and%20it'll%20will%20tell%20them%20how%20many%20actions%20it%20will%20require%20for%20them%20to%20reach%20that%20target.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20based%20on%20the%20sample%20data%20i've%20added%20and%20the%20current%20requirement%20to%20get%20from%20level%203%20to%206%2C%20it%20needs%20to%20pull%20the%20data%20from%20D3%20and%20add%20that%20to%20D4%20%26amp%3B%20D5%2C%20so%20that%20it'll%20tell%20them%20how%20many%20actions%20it%20takes%20to%20reach%20level%206.%20It%20also%20needs%20to%20allow%20for%20those%20first%20parameters%20to%20change%20(cells%20H5%20%26amp%3B%20I5)%20so%20it%20can%20pull%20and%20calculate%20much%20wider%20or%20shorter%20ranges%2C%20depending%20on%20the%20two%20data%20entries%20that%20are%20entered%20by%20the%20user.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHaven't%20used%20excel%20for%20a%20long%20time%20and%20took%20on%20this%20little%20self%20project%20to%20help%20me%20improve%20my%20knowledge%20of%20it%2C%20while%20also%20benefitting%20a%20community%20i%20love%20being%20a%20part%20of.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20Windows%2010%20and%20the%20most%20current%20Microsoft%20Office%20build%2C%20any%20help%20or%20insight%20is%20greatly%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2732509%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2732639%22%20slang%3D%22en-US%22%3ERe%3A%20Calculator%20Project%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2732639%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1149884%22%20target%3D%22_blank%22%3E%40WoodyBRUH%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DSUMIFS(D2%3AD6%2CA2%3AA6%2C%22%26gt%3B%22%26amp%3BH5%2CA2%3AA6%2C%22%26lt%3B%3D%22%26amp%3BI5)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2732660%22%20slang%3D%22en-US%22%3ERe%3A%20Calculator%20Project%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2732660%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIts%20extremely%20close%2C%20the%20result%20for%20the%20sample%20should%20be%2027%20but%20its%20outputting%2030%20for%20some%20reason%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20its%20adding%20the%20difference%20between%20the%202%20inputs%20making%20it%20output%20the%20incorrect%20value%2C%20if%20theres%20any%20way%20to%20stop%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 they want to get to, and it'll will tell them how many actions it will require for them to reach that target.

 

So based on the sample data i've added and the current requirement to get from level 3 to 6, it needs to pull the data from D3 and add that to D4 & D5, so that it'll tell them how many actions it takes to reach level 6. It also needs to allow for those first parameters to change (cells H5 & I5) so it can pull and calculate much wider or shorter ranges, depending on the two data entries that are entered by the user.

 

Haven't used excel for a long time and took on this little self project to help me improve my knowledge of it, while also benefitting a community i love being a part of.

 

I'm using Windows 10 and the most current Microsoft Office build, any help or insight is greatly appreciated!

4 Replies

@WoodyBRUH 

Try

 

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

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?

best response confirmed by WoodyBRUH (New Contributor)
Solution

@WoodyBRUH Try this than:

=SUMIFS(D2:D6,A2:A6,">"&I5-1,A2:A6,"<="&J5-1)

 

yep thats done it, appreciate it!