What I am trying to do is count the number of rows that have the same value in the f cell in that row as the F1 cell and if that is true then I want it to look at the B cell and the C cell and if the B cell <> "SE" and the C Cell <> "RUSH" then count that row. This is what I have so far and do not know how to put the or statement in =SUMPRODUCT(--('Ag 1st'!$F27:$F5226=$F$1),--('Ag 1st'!$B27:$B5226<>"SE")) Please help
Bookmarks