I am not able to work out how to count criteria (ie >0 and <$21.80 for Column H) against a series of ranges
TO EXPLAIN FURTHER
In Cell G289 I have put a count in for the entire column H, however this picks up some cells that I don’t want to count, SO…..
In Cell H299 I have put a count in for the range of cells I need the count on - ie 7 days a week for 13 periods from 1/1/16 - 30/3/16. BUT
that isnt working
What I am trying to count is the number of days an employee has been paid less than the amount in row 10 but more than 0 (to remove the count on days he didn’t work)
Bookmarks