| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Nested Subtotal Formula
Could someone help me debug the following formula? =SUBTOTAL(9,IF(AND(A:A=13,R:R="PRODUCE"),N:N,0)) I am trying to add together numbers in column "N", if column "A" is 13, and column "R" is PRODUCE. Thanks for any help! -- nickimu ------------------------------------------------------------------------ nickimu's Profile: http://www.excelforum.com/member.php...o&userid=26793 View this thread: http://www.excelforum.com/showthread...hreadid=400436 |
|
#2
|
|||
|
|||
|
=sumproduct(--(a1:a1000=13),--(r1:r1000="PRODUCE"),N1:N1000)
"nickimu" wrote: Could someone help me debug the following formula? =SUBTOTAL(9,IF(AND(A:A=13,R:R="PRODUCE"),N:N,0)) I am trying to add together numbers in column "N", if column "A" is 13, and column "R" is PRODUCE. Thanks for any help! -- nickimu ------------------------------------------------------------------------ nickimu's Profile: http://www.excelforum.com/member.php...o&userid=26793 View this thread: http://www.excelforum.com/showthread...hreadid=400436 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
