Posted to microsoft.public.excel.worksheet.functions

L. Howard

external usenet poster

Posts: 852

SUMIF Wild Card formula for two words in cell

Columns E and F. (Text is all in one cell in column E)

AA BB CC 1
QQ WW EE 2
AA SS DD 3
AA BB CC 4
QQ WW EE 5
AA SS DD 6
AA BB CC 7

=SUMIF(E1:E7,"AA*",F1:F7) returns 21

How do I sumif for the cells that have AA & CC which would return 12?

Howard

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
Wild card in formula	Greg Snidow	Excel Programming	7	October 15th 08 08:53 PM
wild card?? formula question please	ferde	Excel Discussion (Misc queries)	6	October 11th 08 01:40 PM
Using wild card in IF formula	gcukarski	Excel Discussion (Misc queries)	3	September 19th 08 12:22 AM
Wild Card for SUMIF criteria	Ronbo	Excel Worksheet Functions	2	December 12th 07 09:09 PM
wild card -- help with formula	Michael A	Excel Discussion (Misc queries)	10	January 8th 06 10:15 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us