D
DLF1
I'm trying to do a count if with 2 criteria - the difficulty I'm having is
the 2nd criteria involves a calculation - please see example below;
Table 1
Col A Col B
ABCD 20/10/2005
Table 2
Col A Col B
ABCD 20/05/2005
ABCD 20/09/2005
I want to count if Col A from Table 2 matches A1 from Table 1 plus B1 from
Table 1 less Col B in Table 2 is greater than 30. I'm probably not explaining
this very well but the answer would be 1. My problem is I can't figure out
how to get avalue for B1 (Table 1) against every row in Col B in table 2. Am
I making any sense at all?
the 2nd criteria involves a calculation - please see example below;
Table 1
Col A Col B
ABCD 20/10/2005
Table 2
Col A Col B
ABCD 20/05/2005
ABCD 20/09/2005
I want to count if Col A from Table 2 matches A1 from Table 1 plus B1 from
Table 1 less Col B in Table 2 is greater than 30. I'm probably not explaining
this very well but the answer would be 1. My problem is I can't figure out
how to get avalue for B1 (Table 1) against every row in Col B in table 2. Am
I making any sense at all?