Posted to microsoft.public.excel.misc

ROHIT

external usenet poster

Posts: 38

sumif formula

i want to use sumif formual with a text.

eg =sumif(A1:A100,"ACC*",F1:F100). is this possible

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
Nesting a sumproduct formula within a sumif formula.	jerrymcm	Excel Discussion (Misc queries)	2	October 3rd 07 03:35 PM
sumif formula doesn't add up	Janis	Excel Discussion (Misc queries)	3	August 14th 07 03:06 PM
multiply formula where 1 cell has a (sumif) formula as a result	kcip	Excel Worksheet Functions	1	May 3rd 07 07:41 AM
sumif formula	alm09	Excel Worksheet Functions	3	December 6th 06 02:30 PM
Is there a MAXIF formula similar to the SUMIF formula?	tlc	Excel Discussion (Misc queries)	2	March 13th 06 08:07 PM

All times are GMT +1. The time now is 10:35 PM.

About Us

"It's about Microsoft Excel"