View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leslie M
 
Posts: n/a
Default How do I make it add a column based on 2 different criteria?

I am trying to add sales gross for individual salespeople, and break it down
by new vehicles vs. used vehicles. I have a column set up for the sales
people, a column set up for the type (N or U), and a column set up for the
gross that I want to add. I can make it add up the gross of new vs. used
using the sumif function, but I don't know how to make it do "if this = this,
and this = this, then add this through this". Does that make sense? I'm sure
it's not as hard as I'm making it out to be. Can anyone help?

Thanks!