View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tasha Tasha is offline
external usenet poster
 
Posts: 157
Default Sumproduct on multiple sheets...please help???

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????