Thread: >< formulas
View Single Post
  #2   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"mpiton" wrote in message
...
A spreadsheet containing two colums. Column A has dollar amount entries.
Column B has date entries. These entries are entered throughout the month
and every month of the year. I need a formula that will sum the amounts

in
column a only if they are during the month of march from column b (for
example)


I think you want SUMIF
http://www.techonthenet.com/excel/formulas/sumif.htm

/Fredrik