If formulas

P

Phil

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
 
B

Bob Buckland ?:-\)

Hi Phil,

You may want to also post this in the MS Excel discussion group through the links below and include there the version of Excel
you're using.

=========
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 <<
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 
Top