Our responses have been based on the above. If you want a sum, =SUMPRODUCT(('Master log'!K:K>'Master log'!L:L)*('Master log'!D:D="HJT"),'Master log'!K:K) and =SUMPRODUCT(('Master log'!K:K<'Master log'!L:L)*('Master log'!D:D="HJT"),'Master log'!L:L). Again, either the first will have to be >= or the second <= to account for instances in which they're equal.I want to count the instances in B where criterion of A is met, not the sum of the numbers in the rows.
Bookmarks