Hi

summary: I need countif to only count an entry if both column a and column b contain data.

Basic Details: I have a worksheet that has column A and Column B that by default contains no data. I need column B to be counted automatically after data is entered. I can achieve this simply using countif cell value > 0. However because the first cell contains a formula it counts it becasue the cell shows as 00:00 (hh:mm format) however I need the cell to contain the formula but not to be counted by the countif function. So to get round this i want it to count column a as well that has no fomula in it so basically the countif will only find 1 entry if both column a and column b contain data.

I would be very grateful for any assistance

Thanks

John