HELP-HELP-HELP
 

I have a sample of the table that I working on as showing below:
Name Date Amount January February ....
Un Nyobe January-08 $56.00
Kwame Krumah June-08 12.00

I would like excel to return amount entered in the "amount column" in a
specific month if the date is within that month. For example, in the month of
January, please entered $56 if the date is anywhere between January 1 thru
31, 2008
--
Phil

HELP-HELP-HELP
 

I Don't know if I have made myself clair.

I was able to build the following formula

=IF(E18DATE(2008,4,30),IF(E18<=DATE(2008,5,31),F1 8),"").

The above is close to what I wanted, meaning if the date in E18, column K
is greater than April 04, 2008, if at the same time date in the same row is
also equal or less than May 05, 2008, display the value in F18, otherwise
leave the cell blank.
HOWEVER, THE FORMULA ABOVE IS NOT WORKING AS I WANTED TO. INSTEAD OF
DISPLAYING A BLANK CELL, IT DISPLAYS "FALSE".
--
Phil


"RagDyer" wrote:

Assuming month names in column headers D to O are text, and dates in Column
B are "legal" XL dates, try this in D2:

=IF($B2,IF(TEXT($B2,"mmmm")=D$1,$C2,""),"")

Copy across to Column O (December),
Then copy the range D2:O2 down as far as needed.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Phil" wrote in message
...
I have a sample of the table that I working on as showing below:
Name Date Amount January February ....
Un Nyobe January-08 $56.00
Kwame Krumah June-08 12.00

I would like excel to return amount entered in the "amount column" in a
specific month if the date is within that month. For example, in the month
of
January, please entered $56 if the date is anywhere between January 1 thru
31, 2008
--
Phil

HELP-HELP-HELP
 

Did you try RagDyer's formula. It looks to me like it will do exactly what
you have asked for.
--
HTH...

Jim Thomlinson


"Phil" wrote:

I Don't know if I have made myself clair.

I was able to build the following formula

=IF(E18DATE(2008,4,30),IF(E18<=DATE(2008,5,31),F1 8),"").

The above is close to what I wanted, meaning if the date in E18, column K
is greater than April 04, 2008, if at the same time date in the same row is
also equal or less than May 05, 2008, display the value in F18, otherwise
leave the cell blank.
HOWEVER, THE FORMULA ABOVE IS NOT WORKING AS I WANTED TO. INSTEAD OF
DISPLAYING A BLANK CELL, IT DISPLAYS "FALSE".
--
Phil


"RagDyer" wrote:

Assuming month names in column headers D to O are text, and dates in Column
B are "legal" XL dates, try this in D2:

=IF($B2,IF(TEXT($B2,"mmmm")=D$1,$C2,""),"")

Copy across to Column O (December),
Then copy the range D2:O2 down as far as needed.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Phil" wrote in message
...
I have a sample of the table that I working on as showing below:
Name Date Amount January February ....
Un Nyobe January-08 $56.00
Kwame Krumah June-08 12.00

I would like excel to return amount entered in the "amount column" in a
specific month if the date is within that month. For example, in the month
of
January, please entered $56 if the date is anywhere between January 1 thru
31, 2008
--
Phil

HELP-HELP-HELP
 

NOT WORKING.
I don't know what Column()-3 stands for? It is returning large number as
refer to the data below:

Input Date Amount January February
January-08 $56.00
March-08 70.00
June-08 12.00 $39,606.00

Thanks for your help.
--
Phil


"MyVeryOwnSelf" wrote:

I have a sample of the table that I working on as showing below:
Name Date Amount January February ....
Un Nyobe January-08 $56.00
Kwame Krumah June-08 12.00

I would like excel to return amount entered in the "amount column" in
a specific month if the date is within that month. For example, in the
month of January, please entered $56 if the date is anywhere between
January 1 thru 31, 2008

One way is to start by putting this in D2:
=IF(MONTH($B2)=COLUMN()-3,$C2,"")

Then extend D2 to the right as far as O2.

Then extend D2:O2 down for as many rows as needed.

HELP-HELP-HELP
 

To avoid the FALSE return, you need to move your bracket:

=IF(E18DATE(2008,4,30),IF(E18<=DATE(2008,5,31),F1 8,""))

Or you could write this with one IF as:

=IF(AND(E18DATE(2008,4,30),E18<=DATE(2008,5,31)), F18,"")

Hope this helps.

Pete

On Jun 24, 11:38*pm, Phil wrote:
I Don't know if I have made myself clair.

I was able to build the following formula

=IF(E18DATE(2008,4,30),IF(E18<=DATE(2008,5,31),F1 8),"").

The above is close to what I wanted, meaning if the date in E18, column K *
is greater than April 04, 2008, if at the same time date in the same row is
also equal or less than May 05, 2008, display the value in F18, otherwise
leave the cell blank.
HOWEVER, THE FORMULA ABOVE IS NOT WORKING AS I WANTED TO. INSTEAD OF
DISPLAYING A BLANK CELL, IT DISPLAYS "FALSE". *
--
Phil



"RagDyer" wrote:
Assuming month names in column headers D to O are text, and dates in Column
B are "legal" XL dates, try this in D2:

=IF($B2,IF(TEXT($B2,"mmmm")=D$1,$C2,""),"")

Copy across to Column O (December),
Then copy the range D2:O2 down as far as needed.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Phil" wrote in message
...
I have a sample of the table that I working on as showing below:
Name Date * *Amount * * * * January * * * *February *....
Un Nyobe January-08 * * $56.00
Kwame Krumah June-08 * * 12.00

I would like excel to return amount entered in the "amount column" in a
specific month if the date is within that month. For example, in the month
of
January, please entered $56 if the date is anywhere between January 1 thru
31, 2008
--
Phil- Hide quoted text -

- Show quoted text -

HELP-HELP-HELP
 

That large number looks like a date which is formatted as currency.
Perhaps your cell references do not co-incide with the formula - what
do you have in C2?

Pete

On Jun 25, 12:29*am, Phil wrote:
NOT WORKING.
I don't know what Column()-3 stands for? It is returning large number as
refer to the data below:

Input Date * * * * * * * * * Amount * * January February
January-08 * * * * * * * * * $56.00 * * * * * * *
March-08 * * * * * * * * * * * 70.00 * * * * * * *
June-08 * * * * * * * *12.00 * * * * * * $39,606.00

Thanks for your help.
--
Phil



"MyVeryOwnSelf" wrote:
I have a sample of the table that I working on as showing below:
Name * * * * *Date * * * *Amount * * * * January * * * *February *....
Un Nyobe * * * * *January-08 * * * * $56.00
Kwame Krumah * * June-08 * * * * 12.00

I would like excel to return amount entered in the "amount column" in
a specific month if the date is within that month. For example, in the
month of January, please entered $56 if the date is anywhere between
January 1 thru 31, 2008

One way is to start by putting this in D2:
* *=IF(MONTH($B2)=COLUMN()-3,$C2,"")

Then extend D2 to the right as far as O2.

Then extend D2:O2 down for as many rows as needed.- Hide quoted text -

- Show quoted text -

HELP-HELP-HELP
 

Date
--
Phil


"Pete_UK" wrote:

That large number looks like a date which is formatted as currency.
Perhaps your cell references do not co-incide with the formula - what
do you have in C2?

Pete

On Jun 25, 12:29 am, Phil wrote:
NOT WORKING.
I don't know what Column()-3 stands for? It is returning large number as
refer to the data below:

Input Date Amount January February
January-08 $56.00
March-08 70.00
June-08 12.00 $39,606.00

Thanks for your help.
--
Phil



"MyVeryOwnSelf" wrote:
I have a sample of the table that I working on as showing below:
Name Date Amount January February ....
Un Nyobe January-08 $56.00
Kwame Krumah June-08 12.00

I would like excel to return amount entered in the "amount column" in
a specific month if the date is within that month. For example, in the
month of January, please entered $56 if the date is anywhere between
January 1 thru 31, 2008

One way is to start by putting this in D2:
=IF(MONTH($B2)=COLUMN()-3,$C2,"")

Then extend D2 to the right as far as O2.

Then extend D2:O2 down for as many rows as needed.- Hide quoted text -

- Show quoted text -

HELP-HELP-HELP
 

NOT WORKING.
... It is returning large number as
refer to the data below:

Input Date Amount January February
January-08 $56.00
March-08 70.00
June-08 12.00 $39,606.00

The formula
=IF(MONTH($B2)=COLUMN()-3,$C2,"")
is based on the layout of the original post, with names in column A.

With the "name" column removed, try instead in C2:
=IF(MONTH($A2)=COLUMN()-2,$B2,"")


I don't know what Column()-3 stands for

Here's the basic idea. Putting COLUMN() in a cell returns a number:
- 1 if the cell is in column A,
- 2 if column B,
- 3 if column C, etc.

Then:
- in C2, COLUMN()-2 is 1 (or for that matter in C3, C4, etc.)
- January is month 1 of the annual calendar.
- So the "IF" is testing for A2 being in January.
- Extending C2 to the right shifts the test to February, March, etc.

Look in Excel's built-in Help for more about COLUMN().