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.

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 64"]Item[/TD]
[TD="class: xl64, width: 64"]Lot[/TD]
[TD="class: xl64, width: 64"]Qty[/TD]
[TD="class: xl64, width: 64"]Station[/TD]
[/TR]
[TR]
[TD="class: xl63"]12012[/TD]
[TD="class: xl63"]88[/TD]
[TD="class: xl63"]10[/TD]
[TD="class: xl63"]KHI[/TD]
[/TR]
[TR]
[TD="class: xl63"]12011[/TD]
[TD="class: xl63"]58[/TD]
[TD="class: xl63"]10[/TD]
[TD="class: xl63"]KHI[/TD]
[/TR]
[TR]
[TD="class: xl63"]13012[/TD]
[TD="class: xl63"]99[/TD]
[TD="class: xl63"]10[/TD]
[TD="class: xl63"]KHI[/TD]
[/TR]
[TR]
[TD="class: xl63"]13011[/TD]
[TD="class: xl63"]99[/TD]
[TD="class: xl63"]10[/TD]
[TD="class: xl63"]KHI[/TD]
[/TR]
[TR]
[TD="class: xl63"]14012[/TD]
[TD="class: xl63"]58[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl63"]KHI[/TD]
[/TR]
[TR]
[TD="class: xl63"]14011[/TD]
[TD="class: xl63"]58[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl63"]KHI[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.