Summing Data based upon a condition

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi,

Trying to "Sum" data in one column (A) based upon a condition in another
column (B)....... Any help?
 
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)
 
Back
Top