Sum Unique Values (Diff Row & Column ) from Different Sh

[Kamal Subhani]

Book1
	A	B	C	D
1	Product	Quality1	Quality3	Quality4
2	A	10	10	10
3	B	20	20	10
4	F	30	10	10
5	E	10	20	30
Sheet1

Book1
	A	B	C	D
1	Product	Quality3	Quality2	Quality5
2	C	10	10	10
3	D	20	20	10
4	A	30	10	10
Sheet10

Book1
	A	B	C	D	E	F
1	Product	Quality1	Quality2	Quality3	Quality4	Quality5
2	A	10	40	10	10	10
3	B	20	20	10	0	0
4	C	0	10	0	10	10
5	D	0	20	0	20	10
6	E	10	20	30	0	0
7	F	30	10	10	0	0
Main

In actual I have more than 10 sheets.

In the main sheet the Unique Products and the Unique quality will be displayed with the help of the formula

In the main sheet the total of each product according to qualties should be dispalyed


Plz help.

I think u undertand my problem.

 

[Aladin Akyurek]

Re: Sum Unique Values (Diff Row & Column ) from Differen

I am posting a new example

Book2
	A	B	C	D	E	F	G	H
1		a	b	e	f	g	h
2
3
4
Sheet1

in sheet2 I have

Book2
	A	B	C	D	E	F	G	H
1		a	b	c	d	e	f
2
3
4
5
Sheet2

in the main sheet I want as follows with the help of UNvalues formula

Book2
	A	B	C	D	E	F	G	H	I	J
1		a	b	c	d	e	f	g	h
2
3
4
Main

hope that Yogi Bro this will help u in understanding me

All this is very disturbing: mianmazher posted the same question a zillion times. Tom (rrdonutz) posted a solution (with UNIQUEVALUES) to this question too when you started to repeat it. The layout is gone from vertical to horizontal... I'm not sure that the following will put an end to it:

In B1 in Main:

=INDEX(UNIQUEVALUES(THREED(Sheet1:Sheet2!$1:$1),1),COLUMN()-COLUMN($B$1)+1)

which must be confirmed with control+shift+enter instead of just enter, then copied across as far as needed.

 

[Kamal Subhani]

Re: Sum Unique Values (Diff Row & Column ) from Differen

I have tried again and again but all in vain

The #name? is comming


Plz help me out Excel Gurus (Yogi Anand Bro)


Plz need ur help to solve this mystery.


Kamal

 

[Kamal Subhani]

Re: Sum Unique Values (Diff Row & Column ) from Differen

Dear Aladin
When I pasted the formula

=INDEX(UNIQUEVALUES(THREED(Sheet1:Sheet2!$1:$1),1),COLUMN()-COLUMN($B$1)+1)

in cell B1 with Ctrl+Shift+Enter

The #name? is comming


Tell me what to do now.

Kamal

 

[Aladin Akyurek]

Re: Sum Unique Values (Diff Row & Column ) from Differen

Dear Aladin
When I pasted the formula

=INDEX(UNIQUEVALUES(THREED(Sheet1:Sheet2!$1:$1),1),COLUMN()-COLUMN($B$1)+1)

in cell B1 with Ctrl+Shift+Enter

The #name? is comming


Tell me what to do now.

Kamal

Did you install the morefunc.xll add-in?

 

[Kamal Subhani]

Re: Sum Unique Values (Diff Row & Column ) from Differen

Ooooooooooops

U just Did It Problem Resolved
CASE CLOSED

Thanx To Aladin (Excel Genie)

(U really Had a magic lamp)


I just Reinstalled the Excel and forget to install the morefunc.xll


Thanx once again Aladin

This Forum Is great

 

[Kamal Subhani]

Re: Sum Unique Values (Diff Row & Column ) from Differen

I want to continue muy Problem as follows

Book1
	A	B	C	D
1		Quality1	Quality2	Quality3
2	A	10	10	10
3	B	10	10	10
4	C	10	10	10
5	D	10	10	10
Sheet1

Book1
	A	B	C	D
1		Quality4	Quality1	Quality2
2	D	10	10	10
3	C	10	10	10
4	E	10	10	10
5	F	10	10	10
6	A	10	10	10
7	B	10	10	10
Sheet2

In the main sheet I want

Book1
	A	B	C	D	E
1		Quality1	Quality2	Quality3	Quality4
2	A	20	20	10	0
3	B	20	20	10	0
4	C	20	20	10	10
5	D	20	20	10	10
6	E	0	0	0	10
7	F	0	0	0	10
Main

I have dispalyed the Quality1, Quality2,Quality3 and Quality4

similarly
A
B
C
D
E
F

Now I want to sum the values from the diffreent sheets as shown in the main sheet.

I an actual I will be having 10 sheets ( or even more)

I think I am able to understand muy Problem

Thanks in advance

Regards

Kamal

 

[Kamal Subhani]

Re: Sum Unique Values (Diff Row & Column ) from Differen

Me waiting for someone to solve my problem
I think Aladin is away Thats why he si not replying


PLz Aladin Bro Help.


KAMAL

 

[Kamal Subhani]

Re: Sum Unique Values (Diff Row & Column ) from Differen

I am trying to use the sumproduct with Threed
But I am not getting the result

like the one posted by
Brian
=SUMPRODUCT(--(THREED(First:Last!A1:A10)=C1),--(THREED(First:Last!B1:B10)))

in the following post
http://www.mrexcel.com/board2/viewtopic.php?t=75458&highlight=

Plz help

I am not getting how to use this sumproduct and Threed to get the desired result.


Kamal

 

[Aladin Akyurek]

Re: Sum Unique Values (Diff Row & Column ) from Differen

I want to continue muy Problem as follows...

How big is the biggest column A -- 100, 1000, 10000 cells?

 

[Kamal Subhani]

Re: Sum Unique Values (Diff Row & Column ) from Differen

Aladin Bro

Column A will have about 3000 Records

I want to sum the Sizes in Column A with according to different qualities in Different columns in Different sheets

Thanks

Kamal