| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can you imbed a sumif
is this possible sumif(a:a,x2,sumif(h:h,y2,j:j))
I have multipul criteria with in multiple criteria 12 joe 25 12 joe 10 12 sue 5 13 joe 18 13 joe 20 13 joe 14 13 sue 19 13 sue 25 14 sue 19 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can you imbed a sumif
Use SUMPRODUCT. You have to specify a range with this.
=SUMPRODUCT(--(A2:A100=X2),--(H2:H100=Y2),J2:J100) HTH, Paul -- "Lori" wrote in message ... is this possible sumif(a:a,x2,sumif(h:h,y2,j:j)) I have multipul criteria with in multiple criteria 12 joe 25 12 joe 10 12 sue 5 13 joe 18 13 joe 20 13 joe 14 13 sue 19 13 sue 25 14 sue 19 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to imbed a cell reference in a text field? | New Users to Excel | |||
| Possible to imbed a Word Doc? (yes) but how to link to subset of i | Excel Discussion (Misc queries) | |||
| Can I imbed a Word Document into an Excel Workbook? | Excel Discussion (Misc queries) | |||
| Excel should let me imbed documents and programs within its-self | Excel Worksheet Functions | |||
| Imbed Linked Word doc in Excel so whole doc shows? | Excel Discussion (Misc queries) | |||
Linear Mode
