Sumproduct on multiple sheets...please help???
If you have dates in column A and days of the month in row 2, then you
are not really comparing like-with-like. Also, do you really need to
go down to row 65,535? - that's a lot of rows of data !!
Anyway, you could try something like this:
=SUMPRODUCT((DAY(ORLog!$A$3:$A$65535)=C$2)*(ORLog! $E$3:$E$65535=$B3))
+ SUMPRODUCT((DAY(SPLog!$A$3*:$A$65535)=C$2)*(SPLog! $E$3:$E$65535=
$B3))
I've adjusted the start or the ranges to row 3, as you appear to have
headings above this. Copy the formula across and down as required.
Hope this helps.
Pete
On Jun 24, 9:58*pm, Tasha wrote:
I am trying to get a total count from two seperate worksheets. *
ORLog *sheet1
SPLog * sheet2
on my summary sheet(Daily), row 2 starting with C contains the dates of the
month across * 1 2 3, etc. *formated for d......and column B starting at B3
has abbrevation names for doctors. *ORLog and SPLog have the same formats and
column headers. *Trying to count for each doctor, from colA(date) in both
ORLog and SPLog....colE has the doctors abbreviated name in both sheets also.
*My formula is below and have been working on for several hours and am still
getting 0's
=SUMPRODUCT((ORLog!$A$2:$A$65535=C$2)*(ORLog!$E$2: $E$65535=$B2)*(SPLog!$A$2*:$A$65535=C$2)*(SPLog!$E $2:$E$65535=$B2))
hoping someone can help me????
|