Formulea
 

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

Formulea
 

This will do it
=SUMPRODUCT(--(MONTH(A1:A6)=4),B1:B6)
best wishes (I am already bald!)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Steveg" wrote in message
...
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

Formulea
 

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
---
"Steveg" wrote:
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

Formulea
 

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


"Steveg" wrote:

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

Formulea
 

Hi,

1 way

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

Mike

"Steveg" wrote:

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