从一个工作表中获取值并更新到另一个工作表的单元格值 [英] get value from one sheet and update to cell values of another sheet
问题描述
您好b $ b
我需要excel的帮助
sheet2中的金额需要将它们放入工作表中1列,如果它在同一张表中增加另一列将为0
如前所述
在sheet2中
Hi
I need a help in excel
there is amounts in sheet2 and need to get them in sheet 1 column and if it increase anothe column in same sheet will be 0
as ex like this
in sheet2
wp02 2000
wp05 9000
wp10 2700
wp20 2500
wp23 5000
sheet 1
wp02 2700
wp03 2850
wp04 1200
wp05 9650
partpayment
1
1
0
0
if i在sheet2中添加wp05值,它应该更新sheet1中的wp05和
partpayemnt应为0
它不适用于我的公式
= IF(D2 = 0,0,IF(Sheet2!B:B< = D2,0,1))
帮我排序o这个
Asathecode
sheet 1
wp02 2700
wp03 2850
wp04 1200
wp05 9650
partpayment
1
1
0
0
if i add wp05 value in sheet2 it should update wp05 in sheet1 and
partpayemnt should be 0
it wont work for my formula
=IF(D2=0,0,IF(Sheet2!B:B<=D2,0,1))
help me to sort out this
Asathecode
推荐答案
你应该读一下SUMIF
或SUMPRODUCT
https://support.office.com/en-us/article/SUMIF-function-169b8c99-c05c-4483-a712-1697a653039b [ ^ ]
https:// support。 office.com/en-us/article/SUMPRODUCT-function-16753e75-9f68-4874-94ac-4d2145a2fd2e [ ^ ]
You should read aboutSUMIF
orSUMPRODUCT
https://support.office.com/en-us/article/SUMIF-function-169b8c99-c05c-4483-a712-1697a653039b[^]
https://support.office.com/en-us/article/SUMPRODUCT-function-16753e75-9f68-4874-94ac-4d2145a2fd2e[^]
这篇关于从一个工作表中获取值并更新到另一个工作表的单元格值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!