如何建立这个复杂的IF公式 [英] How to Build this complex IF formula

问题描述

注意-此图像仅供参考.列"D"，"E"大约有100行

Note- This Image is for representation. Column 'D', 'E' has around 100 rows

在这里，我想在"G"列中显示7100的地方输入一个公式.

Here i want to put a Formula in 'G' column field where 7100 appears.

目前，我自己计算1100 + 1000 + 5000，并在G列中添加和写入7100.我想要一个公式，其中仅当列'D'的前面写有数字时，才添加'E'列中的数字，例如:-10或11，或12，555，666&依此类推……如果在"D"列中未写入任何内容，例如:-在4000旁边，则不应将此4000添加到7100，同样，最后一个"E"字段1000也不会添加为空在"D"列中针对它写的.

At the moment i am myself calculating 1100 + 1000 + 5000 and adding and writing 7100 in the G column. I want a Formula where Numbers in column 'E' are only added if column 'D' has something written in front of it for e.g: - 10 or 11, or 12, 555 , 666 & so on...... If nothing is written in column 'D' like for e.g:- next to 4000 then this 4000 should not be added to 7100 and likewise the last 'E' field 1000 also will not be added as nothing in written in column 'D' against it.

寻求帮助，提出一个这样的公式.

Requesting for help in coming up with such a formula.

推荐答案

将其粘贴在G列的任何单元格中

stick this in any cell in column G

=SUMIF(D:D,">0",E:E)

注意:这仅在D:D列具有数字值时有效

Note: this will only work if column D:D has numerical values

这篇关于如何建立这个复杂的IF公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！