c14

  1. S

    I need to make Sum with 3 criterias

    in C14: I need it to calculate the sum of the remaining months starting this month, also when the location and function match so that C14 = 75 C14 = 90
  2. R

    Find a value based on two inputs

    Hi, I could use some help finding a specific average from two inputs. Not sure if it can be done, but I have been trying to use sumproduct and its not working out very well. I have a Table setup like so. B1:M1 = Jan, Feb, Mar, Apr, May, Jun, July, Aug, Sep, Oct, Nov, Dec A2= Animals B2:M2 =...
  3. JenniferMurphy

    Problem with named ranges

    I swear I've done this before, but it's not working today and I cannot figure out why. In the table below, I have assigned the name "Header" to row 6 and "Footer" to row 12. In C12, I calculate the average of the ratings in C7:C11. In C13, I try to do the same thing, but using the named...
  4. R

    Calculate value of one cell based on values of two other cells

    I need a formula that will place a number in cell AA14 It looks at the value in cell C14. If the value in cell C14 is between the values in AB4 and AC4, place the value in AD4 on cell AA14 If the value in cell C14 is between the values in AB5 and AC5, place the value in AD5 on cell AA14 If...
  5. J

    Tie Multiple Cells to One cells

    hi, I want to make an inventory list. what i gave right now is in Cell A1,A2, A3 etc i have the item, cells B1, B2, B3 etc if for the amount i have of that item, and Cells C1, C2, C3 etc are for its location. i just type those in as i see them, but i want the final list to be listed...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top