Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMPRODUCT using data from multiple worksheets
Makor,
Couple of points. First, what you are doing should work okay. What do you get, an error or a wrong value? Secondly, as you are just adding all the instances of 1, why not use =SUMIF('mkr Calc Data'!F1:F1000,1) or even =COUNTIF('mkr Calc Data'!F1:F1000,1) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Makor" wrote in message ... I am trying to use the SUMPRODUCT function to http://j-walk.com/ss/excel/tips/tip48.htmworksheet - I even tried using named ranges. Here is the calc I am using. =SUMPRODUCT(('mkr Calc Data'!F1:F1000=1)*('mkr Calc Data'!F1:F1000)) Help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct across multiple worksheets | Excel Worksheet Functions | |||
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria | Excel Discussion (Misc queries) | |||
sumproduct multiple values on other worksheets | Excel Worksheet Functions | |||
Sumproduct across multiple worksheets | Excel Worksheet Functions | |||
SUMPRODUCT using data from multiple worksheets | Excel Programming |