Formulea

  • Thread starter Thread starter Steveg
  • Start date Start date
S

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
 
This will do it
=SUMPRODUCT(--(MONTH(A1:A6)=4),B1:B6)
best wishes (I am already bald!)
 
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
 
Back
Top