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 |
=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 |
All times are GMT +1. The time now is 01:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com