contractors

  1. D

    total field

    Access 2013 I have a form (F_WorkingHoursSub) with 3 fields (Workers, Contractors and Total) Sometimes I have the hours for Workers and Contractors, and other times I only have the Total hours. I would like the total field to show Workers + Contractors if this data is entered. But... If I only...
  2. S

    Confirm company has been notified

    Good morning I'm sure this is basic but I'm stumped researching this task. I'm sending emails to about a dozen and a half different contractors in a generic bcc email for verification of payment on hundreds of projects. As the image attachment will show, I want to paste the list of email...
  3. N

    Sum of values based on specific text

    Hi all, hoping this is a nice easy one. I have a list of contractors in column U (they appear more than once). I have an invoice value for each transaction, set against these contractors in column X. Does anyone know a formula to COUNT up the total value per contractor? i.e. the value for AAA...
  4. L

    Sumif from pivot table

    Sumif from pivot table by criteria (Greater Than) 've tried all possible ways, sum if, sum product, index an match, etc. but whenever I go back and filter its also picking up the grand total number located in the pivot table. Therefore in lieu of the correct number (example $17,393) it...
  5. M

    Lookup multiple instances of the same value in a range

    Hi all, I'm trying to lookup every instance of a value (Vendor Name) and return the total sum of each of these rows value from another column (Retention Held). For example - When ABC Contractor is selected in cell R4, I want every instance of ABC Contractors on the Retention Register to be...

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