Summing Data based upon a condition
in [Functions]
|
Prev: How to copy & paste a worksheet but change 1 bit of the formula?
Next: How enter time DURATIONS mm:ss (not clock times), then sum?
From: Chris on 8 Apr 2010 13:05 Hi, Trying to "Sum" data in one column (A) based upon a condition in another column (B)....... Any help? -- Chris
From: Teethless mama on 8 Apr 2010 13:10 Take a look SUMIF function in help menu "Chris" wrote: > Hi, > > Trying to "Sum" data in one column (A) based upon a condition in another > column (B)....... Any help? > > -- > Chris
From: Eduardo on 8 Apr 2010 13:19
Hi, Let's assume you want to sum column B if column A equals customer "A" =sumproduct(--($A$1:$A$1000="A"),$B$1:$B$1000) "Chris" wrote: > Hi, > > Trying to "Sum" data in one column (A) based upon a condition in another > column (B)....... Any help? > > -- > Chris |