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?

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?