Summing Data based upon a condition

[Chris]

Hi,

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

 

[Teethless mama]

Take a look SUMIF function in help menu

 

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