Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 2

IF Function Question

I have two columns: A is Date (format 1-Jan, 14-Feb, 6-Mar, etc.) and B is
Amount ($). I want to search column A and if it contains Jan, I want to sum
the amounts in Column B. How do I accomplish this?

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
IF Function Question	[email protected]	Excel Worksheet Functions	1	January 23rd 08 05:31 PM
IF Function Question	blucajun	Excel Worksheet Functions	6	August 3rd 07 06:35 PM
Function Question	JustOneJawa	Excel Worksheet Functions	2	June 8th 06 08:43 PM
Function Question	Rubix	Excel Worksheet Functions	5	February 7th 06 01:55 AM
Question on "Value" function	Renny Bosch	Excel Discussion (Misc queries)	6	December 31st 04 02:07 AM

All times are GMT +1. The time now is 04:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us