I'm trying to get a COUNTIFS to work where it looks at a date and an ID number then counts data in 3 columns. However, what it needs to do is look at the first column, if it is 0.00 then ignore it, if the next column is 0.00, ignore that too but if there is a number greater that 0.00 in the last column, count it as 1
If there are figures are greater than 0.00 in one or more of the columns then also count it as 1 and total up all the 1's in the formula column.
I've attached a sample, I really hope that helps.
Any assistance will be gratefully received, thank you......