View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Summing Data based upon a condition

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