each data in 2 different sheets and sum in 3rd

[Ollie at Sky]

sheet 1

	A	B	C	D
1	banana	fruit
2	apple	fruit
3	tuna	fish
4	veal	meat

<tbody>
</tbody>

sheet 2

	A	B	C
1	veal	25
2	banana	31
3	tuna	72
4	apple	43
5	banana	19

<tbody>
</tbody>

I need to have sum total of fruit ( answer is 93 ) in 3rd spread sheet.
I tried with sumifs and sum with index/match, couldn't get the formula.

I know I can use vlookup to date match from sheet 1 to sheet 2, or reverse.
Than I can have sum total of fruit, but is there any other way to have not doing that and finish at once in 3rd sheet?

Is it even possible ?

 

[Brettster]

Don't think what you're wanting to do is possible in a single formula.
The reason is that you would need to somehow create an index/lookup to return multiple values in a single array (which, to my knowledge, is not possible).
A much better (and more transparent) way would be as follows:

A	B	C	D
4	Banana	Fruit
5	Apple	Fruit
6	Tuna	Fish
7	Veal	Meat
8
9
10
11
12	Veal	25	Meat
13	Banana	31	Fruit
14	Tuna	72	Fish
15	Apple	43	Fruit
16	Banana	19	Fruit
17
18
19
20 Fruit	93

<tbody>
</tbody>

Where D12 to D16 is:

=INDEX($C$4:$C$8,MATCH($B12,$B$4:$B$8,FALSE))

...and cell B20 is:

=SUMIF($D$12:$D$17,A20,$C$12:$C$17)

Hope this helps.
Brettster.

 

[Ollie at Sky]

Thank you for reply and I would like to ask one more question to ask.
I can use vlooup instead index with match?
I think they dose the same thing.