Menu

Sum based on month

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Dave Peterson

Posts: n/a

Default

You got one reply to your post in .misc.

wrote:

Hello,

I want to get a dollar value of all the contracts won for
a particular month. The date format is 27-Nov-04. I can
get it to work if just "Nov" is used but not with a
complete date. How can I do this? Is there a wildcard
like (*) that I can use? Any help is apprciated.

Mark

--

Dave Peterson

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
UserForm to select current month or earlier	Steve	Excel Discussion (Misc queries)	2	January 21st 05 09:41 PM
How to extract month number from month name	PM	Excel Discussion (Misc queries)	2	January 19th 05 03:07 PM
Pivot Table - Group by Month - Show Items with no data	Dan Reynolds	Excel Discussion (Misc queries)	0	November 28th 04 01:01 AM
calculate month from week number	ankman	Excel Worksheet Functions	2	November 24th 04 01:27 AM
how to add up number of columns based on month eg feb = 2 oct = 1.	cookie	Excel Worksheet Functions	8	November 5th 04 11:18 AM

All times are GMT +1. The time now is 03:08 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement