ExcelBanter - SUMIF nested Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUMIF nested Formula (https://www.excelbanter.com/excel-discussion-misc-queries/119277-sumif-nested-formula.html)

Lugar

SUMIF nested Formula

What I need is to sum column g, if column a = "T01", and column b = P43

Jim Thomlinson

SUMIF nested Formula

You want to use sumproduct...

=sumproduct(--(A1:A1000="T01"), --(B1:B1000=P43), (G1:G1000))

Check out this link for more info on sumproduct...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson

"Lugar" wrote:

What I need is to sum column g, if column a = "T01", and column b = P43

All times are GMT +1. The time now is 09:19 AM.