Formula help

[Emmily]

Hi I am after a formula, that will provide a sum for each month based on the data in Col A1:D

Date	UKN	FX	TEMP
1-Nov-12	346	10	0			Nov-12	Dec-12
2-Nov-12	151	55	0		Total	2318
5-Nov-12	184	17	0
6-Nov-12	131	18	0
7-Nov-12	623	34	0
8-Nov-12	151	42	0
9-Nov-12	182	13	0
12-Nov-12	154	13	0
13-Nov-12	73	13	0
14-Nov-12	65	43	0

<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" span=7 width=64><TBODY>
</TBODY>

 

[Aladin Akyurek]

G3, control+shift+enter, not just enter:

=SUM(IF(TEXT($A$2:$A$11,"mmm-yy")=TEXT(G$2,"mmm-yy"),$B$2:$D$11))