Posted to microsoft.public.excel.worksheet.functions

Owen888

external usenet poster

Posts: 1

SUMIF Question

Does anyone know how to create a sumif formula with an expression in the
critria. Below is the formula I am trying to use.

Thanks!

=SUMIF($J:$L,$J1"6000000",$L:$L)

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
Sumif of Sumif perhaps?	Fred	Excel Discussion (Misc queries)	2	March 29th 06 05:39 PM
SUMIF	Ferg	Excel Worksheet Functions	3	February 28th 06 03:37 AM
SUMIF Question Criteria	Dave	Excel Worksheet Functions	3	February 8th 06 12:48 PM
Embedding a Sumif in a sumif	C.Pflugrath	Excel Worksheet Functions	5	August 31st 05 07:31 PM
sumif Question	Jason	Excel Discussion (Misc queries)	4	March 15th 05 04:11 PM

All times are GMT +1. The time now is 05:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us