Multiple Conditions

C

Curtis

I have a range in one sheet where

Sheet 1 (source data)
row 1 (D1:BY1)=dept (say 1100 through 1800)
Column B (B3:B277)=product code
(d3:by277) contains values

Sheet 2 (summary report)

Row 2 (d2:ad2) = Department
Column B (B4:B277) = Product Code

I need to calculate the sum of the values by department and product code.

I have tried = SUMPRODUCT('[Sheet1]Group Trial Balance -
Current'!$D$1:$BY$1=E$2)*('[Sheet1]Group Trial Balance -
Current'!$B$3:$B$277=$B144)*('[Sheet1]Group Trial Balance -
Current'!$D$3:$BY$277)

but I am not getting the correct value

Please and Thanks
 
M

muddan madhu

try this

=SUMPRODUCT((sheet1!$B$3:$B$277=Sheet2!$B4)*(sheet1!$D$1:$BY$1=Sheet2!D
$2)*(sheet1!$D$3:$BY$277))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top