Conditional Sum
Hi everone,
Say I have this: A B C 1 a1 9 1 a2 10 1 a3 11 1 a1 12 1 a3 13 1 a3 14 2 a1 15 2 a2 16 2 a1 17 2 a2 18 2 a3 19 I want the sum of C values for each value of (A and B). For example, A=1, B=a3, then C=11+13+14=38. Smart formula to do this please? Thanks, Mike |
Conditional Sum
Hi Mike
Use a pivot table for this, don't fiddle with formulas. Faster, safer, more fun, more power. Best wishes Harald "Mike" wrote in message ... Hi everone, Say I have this: A B C 1 a1 9 1 a2 10 1 a3 11 1 a1 12 1 a3 13 1 a3 14 2 a1 15 2 a2 16 2 a1 17 2 a2 18 2 a3 19 I want the sum of C values for each value of (A and B). For example, A=1, B=a3, then C=11+13+14=38. Smart formula to do this please? Thanks, Mike |
Conditional Sum
On Mar 30, 1:05*pm, Mike wrote:
I want the sum of C values for each value of (A and B). For example, A=1, B=a3, then C=11+13+14=38. Depends on what version of Excel you have. For XL2007 and later: =SUMIFS(C1:C100,A1:A100,1,B1:B100,"a3") For XL2003 and earlier: =SUMPRODUCT((A1:A100=1)*(B1:B100="a3"),C1:C100) |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com