truck

This seems like it should be a very easy thing but I've really struggled with it. I simply want to sum the numbers in column O9:O117 if the cell in column O is not blank and the adjacent cell in column V contains the word Truck. Can someone please help me with this?

Hello! I've painted myself into a corner here with an IF/AND/OR statement. This is a generalization of what I'm trying to accomplish in Excel 2016. The column VEHICLE doesn't always contain the word "TRUCK" so it needs to be scrutinized. The following string causes Excel to tell me there is...

Hi thank you in advance for anyone helping with my problem. I have a user form with a combo box that lists truck 1, truck 2 etc up to truck 10 I have three text boxes with start hours, end hours and total hours which all works fine in the user form at updating my table but, What I cant work out...

Dear Forum Members, I have a situation where I receive a lot of files from different sales depots to me on daily basis. These files are identical in nature. All files have three worksheets namely Depot Name, Operator and Order_Details. Only one column (in “Order_Details” worksheet) keeps...

I have been able to work with these with some success. What I am having trouble with is getting the formula to use more than one column to choose the data from. formula =sumifs(tkcol,tkno,dola,dolb,dolc) where tkcol is the truck range, tkno is the truck to match, and the last 3 will have...

Windows 7 Pro, Excel 2016 I have a table that gets updated from an outside source. This table is a list of items on order from many different customers. Every row contains an item #, order #, customer name, peaces on order, weight, ect. When we plan differnt truck loads we assign a truck number...

Hi all I have the following input data that I need to be able to group them into Output PowerPivot 1 and Output PowerPivot 2. The below example is just a simplified version but I would have thousands of row and different column. Could you please help to suggest a method. Really thanks...

Windows 7 Pro, Excel 2016 I have a table that gets updated from an outside source. This table is a list of items on order from many different customers. Every row contains an item #, order #, customer name, peaces on order, weight, ect. When we plan differnt truck loads we assign a truck...

I have a filtered list for expenses (LOA, Travel, Truck) each expense has a different value for a different employee, How can I come up with a subtotal in a separate cell? Total Expenses =$ ?? <colgroup><col><col></colgroup><tbody> Name Personnel Expenses Name 1 LOA Name 2 LOA, Travel...

I have a daily staffing sheet that I'm trying to move firemen from one truck to another. It shows how many firemen are on a truck on a given day. Currently, I have to manually type the name of the Firefighter when moving. I want to try to make this automatic. The sheet is divided into Trucks...

I'm wanting an easier way to pull information I need for work, any solution to this would be awesome! I extract information and paste it on "sheet 2" which contains hundreds of rows and about 15 columns. In column "a" is the list of truck numbers (sometimes and often repeated), in column "h"...

Hi Team, I'm struggling with rounding off scenarios in Excel. Can you help me with the below problem statement. Data- <tbody> Customer Location Sales Qty (MT) Possible Truck Type Truck Type Truck Type(Tolerance) X 20.3 15,20 Y 18.3 16,20 Z 9.9 10,15,20 </tbody> Output...

I need help putting together a formula that will do the following: 1. Search for company name "ABC" in column A, then 2. Search for product category "Books" in column B, (there a 6 different product categories that I will be searching for), then 3. Search for product distribution type "truck" in...

Hey there, We have an inventory question in need of a solution. As it's Monday morning, I'm sure people are raring to go! What we are trying to do is create a dynamic inventory which has re-order alerts and keeps a static/audit record. It works like this - We are a small contractor that has a...