bus

Hi I'm learning about COUNTIFS and I don't understand why this is working in one row and not another. In my first cell in question My Criteria is TECH (E4) in Ranges A2 to A20 and R(G4) is ranges B2 to B20 : I'm using =COUNTIFS($A2:$A20,$E4,$B2:$B20,G4) - and it seems to work, it counts 4...

Hello Guys , I am Beginner in Excel VBA . I have 2 Workbooks with Bus Numbers and Locations . Workbook 1 Contains Bus Locations in A ,C,E,G and Bus Numbers in Column B, D,F,H. Workbook 2 Contains some Random Bus Numbers In Column A and Missing Bus Locations in Column I . Workbook 1 gets...

Thank you in anticipation. I have multiple tabs on a worksheet that are ordered thus (the numerals are times but set as text): Bus 14.10 Bus 14.40 Bus 15.10 Car 14.15 Car 14.45 Car 15.15 Plane 14.20 Plane 14.50 Plane 15.20 I would like to sort the tabs in TIME order.

<tbody> Car Bus Train Result 1 1 Car, Bus 2 2 Bus, Train 1 No Car, Train 7 3 Car, Bus 10 Yes Car, Train </tbody> Request your help to have a formula in excel to get a result as shown above. Cells could have numbers or blanks or text. if there is any number/text in any cell(s)the...

Hi , I want to incorporate Sumifs formula where my sum range is dynamic basis the given criteria. For ex : In below data, i want to find sum of Sample 2 , for Business A and level 1 as my criteria. and sum should be for all YTD columns, so in case i change June as YTD, sum should include June...

Hi All, I have searched many threads but cant find the answer. I have a table of how many times a bus has not made its bus stop in time. I want to see the worst 10 bus numbers. I have used the filter top 10 but this shows me about 18 Rows of data in the pivot table, i just want to see the top...

Hi, I require some help please. I am looking for an equation to that will sum based on multiple adjacent cells have specific terms. I need to total the revenue in row D for all lines that have a specific working in Row A B and C See example below: I need a formula to automatically calculate...

Guys, im pretty sure this is not possible but wanted to check. I have a list of vehicles in column A and a list of 4 names in D1:D4 (dave, bob, jim and steve). I was wondering if it is possible to allocate the vehicles equally to the people named in D1:D4 so each person has an equal amount of...

I hope this makes sense? I'm creating a budget for a tour company that occasionally use bus drivers. I want the formula in C3 to reference cells A1 and B2. If the number of bus drivers (cell A1) is greater than 0 - then I need to add the accommodation costs (from cell B2) to the vehicles...

Hi All, Hopefully i wont confuse this matter. I have for example a bus timetable. <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> 2 3 4 5 2 60 70 80 90 3 70 80 90 90 4 80 90 90 10 5 90 100 110 120...