Summing Data based upon a condition

C

Chris

Hi,

Trying to "Sum" data in one column (A) based upon a condition in another
column (B)....... Any help?
 
E

Eduardo

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)
 
Top