| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF nested Formula
What I need is to sum column g, if column a = "T01", and column b = P43
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Hyperlink in nested formula not linking | Excel Discussion (Misc queries) | |||
| How do I set up a nested SUMIF formula for a number of variables? | Excel Worksheet Functions | |||
| I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions | |||
| sumif formula returns incorrect value | Excel Worksheet Functions | |||
Linear Mode
