hi guys,
can someone help me on how to get the sum or computation based on cell reference on another sheet? I have attached a sample workbook.
thanks.
stoey
hi guys,
can someone help me on how to get the sum or computation based on cell reference on another sheet? I have attached a sample workbook.
thanks.
stoey
Last edited by stoey; 03-09-2014 at 09:48 AM.
Try
" =SUMIF('1'!A1:B31,Sheet3!A2,'1'!B1:B31)" in C2 and copy down.
Regards,
Zaska
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks