Formula Madness
 

Hi!

Hope someone can help, I'm sure it's pretty easy to sort out.

I have an expenses spreadsheet. I have to make monthly totals from a
continuous spreadsheet. For example, on my worksheet 'Expenses', coloumn A is
a date in 01/01/07 format, and coloumn B is a total spent on the
corresponding date. On the next worksheet 'Monthly Totals' I have seperate
boxes for each month, Jan - Dec, and in each I obviously need to put a
formula that will basically create a total for each relevant month based on
the data from the expenses worksheet. So for January I'd be looking for a
formula that added up any items in coloumn B that fall within January.

Does that make sense? Very grateful for any help with this.

Thanks

Formula Madness
 

=SUMPRODUCT(--(Sheet1!A2:A20-DAY(Sheet1!A2:A20)+1=--"2007-01-01"),Sheet1!B2:B20)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"IoHeFy" wrote in message
...
Hi!

Hope someone can help, I'm sure it's pretty easy to sort out.

I have an expenses spreadsheet. I have to make monthly totals from a
continuous spreadsheet. For example, on my worksheet 'Expenses', coloumn A
is
a date in 01/01/07 format, and coloumn B is a total spent on the
corresponding date. On the next worksheet 'Monthly Totals' I have seperate
boxes for each month, Jan - Dec, and in each I obviously need to put a
formula that will basically create a total for each relevant month based
on
the data from the expenses worksheet. So for January I'd be looking for a
formula that added up any items in coloumn B that fall within January.

Does that make sense? Very grateful for any help with this.

Thanks

Formula Madness
 

Another way is to use a helper column, say C and put this in C1 and copy
down.....

=TEXT(A1,"mmmm")

Then use this in D1 for the answer.........

=SUMIF(C1:C10,"January",B1:B10)

Vaya con Dios,
Chuck, CABGx3




"IoHeFy" wrote:

Hi!

Hope someone can help, I'm sure it's pretty easy to sort out.

I have an expenses spreadsheet. I have to make monthly totals from a
continuous spreadsheet. For example, on my worksheet 'Expenses', coloumn A is
a date in 01/01/07 format, and coloumn B is a total spent on the
corresponding date. On the next worksheet 'Monthly Totals' I have seperate
boxes for each month, Jan - Dec, and in each I obviously need to put a
formula that will basically create a total for each relevant month based on
the data from the expenses worksheet. So for January I'd be looking for a
formula that added up any items in coloumn B that fall within January.

Does that make sense? Very grateful for any help with this.

Thanks