Nadia

Posts: n/a

SUMIF problem

I have a column that contains the following text cells:
abc - 123
abc - 455
abc - 333
zzzzsyt
wwtrtzz

I just want to sum up the values corresponding to any cell
that has an "abc - " in it. How do I do this? I've tried:
=SUMIF(range,"*abc*",range) but it doesn't work. Please
help!

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
How to use SUMIF to return sums between two values located in cells	ScottBerger	Excel Worksheet Functions	2	April 23rd 23 09:05 PM
SUMIF PROBLEM	puzzledfe	Excel Worksheet Functions	3	January 21st 05 05:19 PM
Row Autofit problem Excel 2003	Matthias Klaey	Excel Discussion (Misc queries)	0	January 19th 05 05:33 PM
SUMIF problem	Hodge	Excel Worksheet Functions	1	November 11th 04 11:48 AM
SUMIF problem	Hodge	Excel Worksheet Functions	1	November 11th 04 11:02 AM

All times are GMT +1. The time now is 01:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us