| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a formulea for calculating a month | Excel Discussion (Misc queries) | |||
| filter list of text for unique entries using formulea | Excel Worksheet Functions | |||
Hybrid Mode
