LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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????
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumproduct for multiple sheets [email protected] Excel Worksheet Functions 6 January 25th 07 09:47 PM
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA Amaxwell Excel Worksheet Functions 4 August 17th 06 06:23 AM
sumproduct looking at multiple sheets BSantos Excel Worksheet Functions 4 February 27th 06 07:40 PM
Sumproduct accross multiple sheets guilbj2 Excel Discussion (Misc queries) 1 September 10th 05 12:11 AM
sumproduct from multiple sheets Matt Excel Worksheet Functions 3 August 3rd 05 07:13 PM


All times are GMT +1. The time now is 01:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"