View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sofia sofia is offline
external usenet poster
 
Posts: 5
Default sum a column based on multiple other columns being true

I am trying to sum amounts based on meeting multiple criteria in other
colums. I saw the response to the "contruction guy" posted here, but it does
not work for my information?

Month Client Amt
Jul Smith 5
Jul Smith 2
Aug Smith 3
Aug Scott 10

I want to calculate total amount per client each month using "sum" and "if"
statements.

Thank you,

sofia