lookup value from another sheet

[sna]

Hi there

i need your help how to write formula to get the value from column F .there're many sale persons in the report
so i need to get total value from all sales people on another sheet because report in sheet0 always update

thanks

[norkaz]

..
Hi guy,
I'm not quite sure what exactly the results you need.
I guess the last cell in column F is the exact number that you need for the output result.

If yes, the lookup function would be better to solve that.

=LOOKUP(10^10,Sheet0!F:F)

Norkaz

[sna]

Hi Norkaz ,
It is working but how another column because it has ,so we need to use SUMIFS .for example column AD because data update daily so I don't want to sum then lookup.

Thanks

[norkaz]

...

Hi guy,

To make something clear, please help to give us
1) The attached Excel file
+ 2) The sample answers that you need
+ 3) The criteria for that...

Norkaz