Thread: Countifs and Dates

Hey everyone,

Here's my problem: I need to use COUNTIFS to count if pieces of equipment have had maintainence done after a specific date, and what class it is (T1/T2/T3).

Constraints: I want the date to be entered in a cell by the user.

Here's the formula I'm attempting to use, but it keeps coming up as zero. If I break the formula into two COUNTIF statements (splitting each statement into it's own cell), I positive numbers (which is ideal). When combining, I get zero...


Main Formula (results in zero):
=COUNTIFS('Transformer Oil'!H:H,">="&Calculations!O32,'Transformer Oil'!D:D,"T1")

Two Seperate Formulas (results in positive whole numbers [Good!])
=COUNTIF('Transformer Oil'!H:H,">="&Calculations!O32)

=COUNTIF('Transformer Oil'!D:D,"T1")


Does combining COUNTIF statements into a single COUNTIFS, when there is date formatting, automatically make it zero? I can't figure this one out... Thanks in advance!

NBVC and zbor, you guys nailed it. You guys were right. I had thought they were in the exact same rows, but they are offset by one. I was confused because the T1 column is merged every two vertical cells, but they start 1 row higher than the dates.

Here's an example, assume T1 is merged for 2 rows at a time. (X refers to another description).

T1.........X
.............Date
T1.........X
.............Date


So, here poses another question. What function would be able to check if that piece of equipment is T1, and maintenance occurred after specified date, assuming they are offset by each row? Thanks in advance!

Zbor, thanks again. I definitly appreciate your help!