• 411K Members
• 5,542 Online
• 466K Conversations
SOLVED

New Contributor

# Computing the sum of a range based on a separate column with variable input values.

I am trying to solve for a range of numbers based on a value I choose. For example in Column A: I have a depth values in 0.05 m increments. I want to take a depth range from Column A (d-8b to d+4b, where d is depth and b is length value) then sum the cells in Column F that correspond to this range. d and b are in cells above the data so I can adjust them to suit my specific needs. I would like a cell that has a formula that gives me the sum of the values in column F that correspond to the depth range of d-8b to d+4b (from Column A). Please, if you have experience doing something like this, provide me with some insight. Please request clarification if my question is unclear. Thanks!

5 Replies

# Re: Computing the sum of a range based on a separate column with variable input values.

Please attach your sample file with manually entered results and the logic of each result.

# Re: Computing the sum of a range based on a separate column with variable input values.

Spoiler

Please find attached the sheet. Refer to Sheet2. I have included a photo in the sheet with my manual calculation.

Thanks again,

Jaret

Solution

# Re: Computing the sum of a range based on a separate column with variable input values.

In the attached version of your file, the formula in F3 is:

=SUMIFS(F8:F1507,A8:A1507,">="&B2-(8*B3),
A8:A1507,"<="&B2+(4*B3))/
(((B2+(4*B3))-(B2-(8*B3)))/F2)

# Re: Computing the sum of a range based on a separate column with variable input values.

Thank you so much! I appreciate the help @Twifoo

# Re: Computing the sum of a range based on a separate column with variable input values.

You’re very much welcome!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies