Formulea

[Steveg]

if anybody out there can help a man from pulling his hair out having spent
what feels like an lifetime trying to create a simple formulea to look at
column A for any dates in the month of april and calculate the total and
place it in column F

A B F
02/04/09 21.00 ******
28/04/09 20.00
30/04/09 9.00
02/05/09 30.00
30/05/09 42.00
01/06/09 86.00

Steve

 

[Bernard Liengme]

This will do it
=SUMPRODUCT(--(MONTH(A1:A6)=4),B1:B6)
best wishes (I am already bald!)

 

[Max]

One way
In F1: =SUMPRODUCT(--(TEXT(A1:A20,"mmmyy")="Apr09"),B1:B20)
Better to make it unambiguous using "mth/yr" instead of just "mth"
Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Teethless mama]

=SUMPRODUCT((MONTH(A1:A6)=4)*(YEAR(A1:A6)=2009),B1:B6)

 

[Mike H]

Hi,

1 way

=SUMPRODUCT((MONTH(A1:A20)=4)*(B1:B20))

Mike