Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table vs formula
I can get this info via pivot table, but there has to be a way to get sum it
via a formula. I have multiple worksheets and each has multiple rows/columns of data. I want to use 2 different sets of criteria (from different worksheets) to sum multiple columns of numbers in the master worksheet. I keep getting #N/A. {=SUM(IF(($A2=Customer!$F$1:$F$800)*($B2=Sales!$H$ 1:$H$800),Master!L$1:O$800,FALSE))} Can anyone help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table vs formula
Try this...
=SUMPRODUCT(--($A2=Customer!$F$1:$F$800), --($B2=Sales!$H$1:$H$800),Master!L$1:O$800) Check out this link... http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "sk8gfast" wrote: I can get this info via pivot table, but there has to be a way to get sum it via a formula. I have multiple worksheets and each has multiple rows/columns of data. I want to use 2 different sets of criteria (from different worksheets) to sum multiple columns of numbers in the master worksheet. I keep getting #N/A. {=SUM(IF(($A2=Customer!$F$1:$F$800)*($B2=Sales!$H$ 1:$H$800),Master!L$1:O$800,FALSE))} Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Formula help | Excel Discussion (Misc queries) | |||
Pivot table formula help | Excel Worksheet Functions | |||
Pivot table for formula | Excel Worksheet Functions | |||
Formula in Pivot Table | Excel Programming | |||
Add a formula to Pivot Table | Excel Worksheet Functions |