THREED function question

simonf

Board Regular
Joined
Jun 18, 2002
Messages
207
Book2(1).xls
ABCDEFG
1Amortization&depreciation267F/XRATE1.5CAD
2Bankcharges400
3Interestexpense644
4Managementfees70,412
5Officeexpense24,106
6Payroll-
7Professionalfees49,859
8Promotion3,720
9Rent-
10Rentals-
11Telephone-
12Training763,385
13Travel-
14
15
16
17Sheet2y1
18Sheet3y1
19Sheet4y1
20Sheet5y1
21Sheet60
22Sheet7y1
Sheet1


Why are the cells picking up the wrong numbers? The numbers also changes everytime I change the value in C17:C19. The data sheets follow.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

simonf

Board Regular
Joined
Jun 18, 2002
Messages
207
Book2(1).xls
ABCD
1Amortization&depreciation0
2Bankcharges0
3Interestexpense0
4Managementfees29,493
5Officeexpense36,158
6Payroll0
7Professionalfees74,788
8Promotion5,580
9Rent0
10Rentals0
11Telephone0
12Training1,145,078
13Travel0
Sheet2
 

simonf

Board Regular
Joined
Jun 18, 2002
Messages
207
Book2(1).xls
ABCD
1Amortization&depreciation400
2Bankcharges100
3Interestexpense300
4Managementfees40,325
5Officeexpense0
6Payroll0
7Professionalfees0
8Promotion0
9Rent0
10Rentals0
11Telephone0
12Training0
13Travel0
Sheet3
 

simonf

Board Regular
Joined
Jun 18, 2002
Messages
207
Book2(1).xls
ABCD
1Amortization&depreciation0
2Bankcharges500
3Interestexpense667
4Managementfees35,800
5Officeexpense0
6Payroll0
7Professionalfees0
8Promotion0
9Rent0
10Rentals0
11Telephone0
12Training0
13Travel0
Sheet4
 

simonf

Board Regular
Joined
Jun 18, 2002
Messages
207

ADVERTISEMENT

Darn, this example is not working well. I just realize the F/X division but the one from my work which looks almost like this has the problem I described. I'll repost later. Sorry for the trouble.
 

simonf

Board Regular
Joined
Jun 18, 2002
Messages
207
Book2(1).xls
ABCDEFG
1Amortization&depreciation783F/XRATE1.5CAD
2Bankcharges1,175
3Interestexpense1,500
4Managementfees1,500
5Officeexpense126
6Payroll126
7Professionalfees4,000
8Promotion4,000
9Rent-
10Rentals-
11Telephone-
12Training-
13Travel4,000
14
15
16
17Sheet20
18Sheet3y1
19Sheet4y1
20Sheet5y1
21Sheet6y1
22Sheet70
Sheet1


Ok, here it is. Notice cells seem to be duplicating? I'll post the other sheet up.
 

simonf

Board Regular
Joined
Jun 18, 2002
Messages
207

ADVERTISEMENT

Book2(1).xls
ABCD
1Amortization&depreciation350
2Bankcharges25
3Interestexpense0
4Managementfees0
5Officeexpense100
6Payroll0
7Professionalfees3,500
8Promotion0
9Rent0
10Rentals0
11Telephone0
12Training0
13Travel4,000
Sheet5
 

simonf

Board Regular
Joined
Jun 18, 2002
Messages
207
Book2(1).xls
ABCD
1Amortization&depreciation0
2Bankcharges250
3Interestexpense50
4Managementfees6,750
5Officeexpense26
6Payroll0
7Professionalfees500
8Promotion1,500
9Rent0
10Rentals220
11Telephone0
12Training10,875
13Travel0
Sheet6
 

simonf

Board Regular
Joined
Jun 18, 2002
Messages
207
Book2(1).xls
ABCD
1Amortization&depreciation610
2Bankcharges100
3Interestexpense200
4Managementfees129,284
5Officeexpense0
6Payroll0
7Professionalfees0
8Promotion0
9Rent0
10Rentals0
11Telephone0
12Training0
13Travel0
Sheet7
 

simonf

Board Regular
Joined
Jun 18, 2002
Messages
207
Humm, looks like if I don't use the IF statement, it works.

SUMPRODUCT((THREED(Sheet2:Sheet4!B12))*($C$17:$C$19))+SUMPRODUCT((THREED(Sheet5:Sheet7!B12))*($C$20:$C$22))/$E$1

Any ideas why the IF doesn't work?
 

Forum statistics

Threads
1,144,363
Messages
5,723,917
Members
422,527
Latest member
JayTheKaz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top