Hello,

I currently have this function: =COUNTIF(North!D:D,">="&C3)-COUNTIF(North!D:D,">"&C4)
what this does is it counts how many dates in a worksheet called "North" are between the dates in cells C3 and C4.

The problem i'm having is, i now need to create a function that will look at column C (that has pump names in it) in worksheet "North", and if it finds the same pump in worksheet named "NorthEquip", it will count it, and then give me that total in a different column.

Thanks!