K
KennyD
Okay, trying to figure one out here (although Dave Peterson could probably
do it in his sleep ).
I have two sheets, Sheet_2 and dB_File. I want to use an employee number to
count the number of sales an employee has made for a particular month.
for example, Cell G13 on Sheet_2 has the employee number and Cell G1 has the
reporting period date (mm/dd/yyyy - i.e. 3/1/2010). In cell G17 on Sheet_2,
I want to count the number of sales that employee number 203 made 3 months
before the reporting period date (i.e. in 12/2009). The employee number is
in Column B of the dB_File sheet and the date the employee made the sale is
in Column BQ of the dB_File sheet. But I don't know how to constrain it to
just the month 3 months ago. This is what I have so far, but don't know how
to finish it.
countifs ( range 1 criteria 1
range2(the date col)
"=COUNTIFS(dB_File!$B$2:$B$99999,Sheet_2!$G$13,dB_File!$BQ$2:$BQ$99999, ?)
I just can't seem to figure out the date criteria. Would it be something
like ...
Date(Year($G$1),MONTH($G$1)-4)? ($G$1 is the date of the current reporting
period.)
do it in his sleep ).
I have two sheets, Sheet_2 and dB_File. I want to use an employee number to
count the number of sales an employee has made for a particular month.
for example, Cell G13 on Sheet_2 has the employee number and Cell G1 has the
reporting period date (mm/dd/yyyy - i.e. 3/1/2010). In cell G17 on Sheet_2,
I want to count the number of sales that employee number 203 made 3 months
before the reporting period date (i.e. in 12/2009). The employee number is
in Column B of the dB_File sheet and the date the employee made the sale is
in Column BQ of the dB_File sheet. But I don't know how to constrain it to
just the month 3 months ago. This is what I have so far, but don't know how
to finish it.
countifs ( range 1 criteria 1
range2(the date col)
"=COUNTIFS(dB_File!$B$2:$B$99999,Sheet_2!$G$13,dB_File!$BQ$2:$BQ$99999, ?)
I just can't seem to figure out the date criteria. Would it be something
like ...
Date(Year($G$1),MONTH($G$1)-4)? ($G$1 is the date of the current reporting
period.)