Offset?

[her.rockstar]

Hi again,

I'd like to have a cell count the number of times it sees %100 in a particular column, only if it matches a certain criteria (ie, the name of the shift)

You'll see in the attached file

book4.xls

[Harribone]

=COUNTIFS(A:A,T3,P:P,1) Type into U3 and drag down. I'm not sure if this is compatible with 2003 though. If not:

In Q1:
=IF(P1=1,A1,"") then drag down.

Then in U3:
=COUNTIF(Q:Q,T3)

Note: "1" is used in the formulas which is the same as 100% (0.5 =50%, 1.5 = 150% etc)

[her.rockstar]

Hey thanks for the idea! Yeah 2003 doesn't have countifs from what I can tell. The second idea will work great

[Mazzaropi]

You can use too: T3 --> =SUMPRODUCT((A1:A16=T3)*(P1:P16=100%))
Copy down the formula

[Harribone]

Good old sumproduct, I always forget about that one! Much neater a solution especially if you will have many many rows of data.