View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Looker1 Looker1 is offline
external usenet poster
 
Posts: 4
Default I want to add totals using several criteria from different column

I am using excel, on XP 2003 SP2 (might be 3)

I am trying to add amounts together using several criteria. I have a column
called "sales type" (of which there are many types) I then have a column of
the month they are paid (Jan, Feb, Mar, etc.etc.)

I want to show in a cell the sales value of a "sales type" in a given
"month" using a formula instead of selecting each cell manually and adding it
to a simpl addition sum string.

Any help much appreciated!