If column A contains X, total value Y in column B

[wardga]

Hi

I'm trying to create a new spreadsheet to detail my expenses for the year. I can't upload an example because I'm at work and it won't allow. So, I'll try and explain.
Column A is transaction date, Colum B is statement month, Column D is the expense reason and column E is the amount (forget C for now). In column G I've got the months of the year, Jan-Dec listed in cells 2-13. What I want is for in column H, cell 2 (next to January) it to total all the vlaues in column E that relate to January's statement. The statement date is in column B, as mentioned.

Hope that makes sense and appreciate help.

Secondly, Pretty well the same as the above but I want it to total the reason totals. So, coulmn D shows the reason, column I lists them (similar to the months) and column J I want to add the total values from column E that relate to that reason category stated in column D.

Finally and not essentially, my card statements are from the 11th-10th monthly. So, If I buy something on 5th February, that counts on January's statement. Now obviously I can enter the statement month manually in column B. But I wondered if it's possible for column B to calcualte the statement month based on the transaction date entered in column A.

all help much appreciated.

[zbor]

Upload example workbook

[Fotis1991]

Hi

Regarding this..

....I can't upload an example because I'm at work and it won't allow. So, I'll try and explain....

Try this

In H2

=SUMPRODUCT((MONTH($A$2:$A$10)=MONTH(G2))*($E$2:$E$10))

In J2

=SUMPRODUCT(($D$2:$D$10=I2)*($E$2:$E$10))

3) i don't understand the third request.

Hope to helps you.

[wardga]

Hi Fotis

thanks for response - the second one works! the first answer returns the #VALUE!

[Fotis1991]

Hi