Hoping to get some help from the experts. I need to find the percentage of days utilized compared to the total amount of days. I have four pieces of equipment listed in one column B3:B6 and twenty-six days from 04-21-17 to 05-16-17 each as a column D2:AC2. The numbers in each column under each day is the amount of trips the vehicle took. I don't care about the number of trips, I only care that the vehicle made a trip that day or not. so if the amount of trips is greater than 0 I want to count it as true and if the amount of trips is zero I want to count it as false, then get a percentage of trues compared to available days. hope someone can help...
Bookmarks