Short Cut Data Find Against V-lookup, SUMIF, COUNTIF

[majidsiddique]

hi all,
kindly anybody tell me short cut to find out desired output if possible.
i have a record on station wise separate sheet. 50 sheets station wise.
i apply:
=VLOOKUP(F2,A2:D7,3,0)+VLOOKUP(F2,Sheet2!A2:D7,3,0)+++++
this is too lengthy.
is there any short cut to find Vlookup countif, SUMIF formula?
Thanks.

Item	Lot	Qty	Station
12012	88	10	KHI
12011	58	10	KHI
13012	99	10	KHI
13011	99	10	KHI
14012	58	5	KHI
14011	58	5	KHI

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[footoo]

Maybe put a formula on each sheet : =VLOOKUP(Sheet1!F2,A2:D7,3,0) - can do by selecting all sheets and entering formula in desired cell.
Then sum all sheets : =SUM(Sheet1:Sheet50!A1)

 

[majidsiddique]

Hi Footoo,
i use it but did not find any result.
=SUM(G2+Sheet1!G2+Sheet2!G2+sheet3!G2+.....)
this is working but how to select all sheets at once.
many Thanks to reply.

 

[footoo]

this is working but how to select all sheets at once.

Select Sheet2, hold down Ctrl and select the last sheet.

If Sheet50 is the last sheet, the formula on Sheet1 : =G2 + SUM(Sheet2:Sheet50!G2)

 

[majidsiddique]

Dear Footoo,
i trying but failed,
please share demo.
Thanks.

 

[footoo]

Sorry - hold down Shift (not Ctrl).

 

[majidsiddique]

Thats great Footoo.
Thanks a lot.