concrete

  1. C

    Counting when multiple revisions of an item are present

    Hi, I have a material log and each material is assigned a status ( either A,B,C, or D). I need to count the no. of materials with each type of status ( No of items with status A,B etc) The catch is that the materials are duplicated and are arranged according to their revisions ( The item "...
  2. R

    Return Range of Value if Criteria Matches another Range

    Hi All, I need to create a register to track the cost of concrete. There is a range of concrete mixes with varying costs. I want to have a drop down list so you can select the Mix which will then automatically return the cost per m3 I have set up a DATA ENTRY TAB which lists the ranges of...
  3. W

    Conditional Sum from different sheet

    Hello!If you look at the image, I'm trying to sum the total number of hours for a week for concrete repairer, skilled op, labourer etc...https://ibb.co/fYYSKnThe sum should be on a different page and looks like thisTrade Total HoursConcrete RepairerLabourerSkilled OpI...
  4. M

    Using wildcard but omitting keyword

    In column A I have List of names and column G I have areas. Column A Pavement Concrete Pavement Concrete Sidewalk Pavement Concrete Pervious Building Standard =(SUMIF($A$12:$A$209,"PAVEMENT *",$G$12:$G$209))+(SUMIF($A$12:$A$209,"*BUILDING*",$G$12:$G$209))+(SUMIF($A$12:$A$209,"PROPOSED POND...
  5. M

    Need Help creating formula: COOLING CONCRETE USING ICE

    Hello, If anyone is up to the challenge.. I have this formula below that I need to modify but don't know how... And I really need the boards help.. What I need is instead of the formula returning: "T = final temperature of concrete mixture (deg F)" I need it to return: "Wi, Weight of the Ice...
  6. D

    Vba Programming

    in my combo box i have selected a range as a drop down to show but the range has multiple duplicate entries how to combine the same values to show as one in the combobox right now range is like this indirect costs indirect costs indirect costs sitework sitework sitework concrete...
  7. Z

    Formula help to add on existing one i have now

    =IFERROR(VLOOKUP($A$4:$A$208,'ConcretePrices'!$A$1:$B$505,2,0),"") Hi I am using this formula. I have this in column D on sheetBase EST. Which pulls the value from Concrete Prices tab in column B 125.00 because Column A matches 1,000. But what I am trying to add on this formula or make a...
  8. PivotMeThis

    Chart with a 'theoretical line' based on user input

    I've been asked to create a file that users can add data to which would be depicted on a chart. A brief explanation: This will be used when constructing a drilled shaft. A drilled shaft is a hole (drilled into the ground) that does not have a standard depth or width. As the hole is drilled...

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