sumif or vlookkup

  1. N

    count number of unique records for each date

    Hi, I have a large report, that I want to be able to count the number of vehicles that worked on a specific date. This is how the data is being presented:- A B C 1 Truck: Truck 1 SEMI TRAILER 2 Hauler: abc cartage 3 20/04/2010 12:06:13 PM 8158540 4...
  2. R

    SumIF or Vlookup?

    I want to create a summary of account Balances. I want it to look like the example below. A formula to Sum all Amounts from Column F for Account Code "A" (in Column B) A_______B_______C_________D_________E_____F Date___Code#_Description____Debit___ Credit_____Total...

Some videos you may like

This Week's Hot Topics