View Single Post
  #1   Report Post  
thornomad
 
Posts: n/a
Default SUMIF & MONTH() ?

Hi,

I have a spreadsheet that contains a list of dates in A column, text in B
column, and amounts in C column (simple bookkeeping).

On a different sheet in the workbook, I want to collect the totals by month
(for budgeting). How can I setup a formula that will SUMIF by MONTH ? I just
want it to scan the whole list and total the amounts for a given month but I
can't 'seem to figure it out.

Thank you,

D