jnorton

Posts: n/a

Sum if certain criteria is met

I have a column with dates in it (Jan-12-2004) I have another column with the
transaction price in it like $21.95.

I need to sum the column by month. I can do mid(Jan-12-2004,1,3) to take out
the info except Jan but then how do you sum from that point on.

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
Max value that meets a criteria	David Burr	Excel Worksheet Functions	6	February 16th 05 01:31 PM
SUM IF Criteria	stacey	Excel Worksheet Functions	3	December 31st 04 12:22 AM
SUMIF with more than 1 criteria	Mike@Q	Excel Worksheet Functions	4	November 26th 04 12:17 AM
Counting "rows", i.e. simultaneous criteria for multiple cells	gkline	Excel Worksheet Functions	2	November 19th 04 07:30 AM
Can I use a cell reference in the criteria for the sumif function.	Number Cruncher	Excel Worksheet Functions	2	November 4th 04 07:52 PM

All times are GMT +1. The time now is 06:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us