Posted to microsoft.public.excel.misc

Abdul Shakeel Abdul Shakeel is offline

external usenet poster

Posts: 39

Precedents

Hi All,

I am using sumif worksheet function in sheet I would like to give an example
here...
Apples 100
Apples 100
Mangos 150
Apples 10
I am using this formula in cell B5:
=Sumif(A1:A4,A5,B1:B4) I just want that when I press
Ctrl + [ in my sumif holding formula it select only those cell that meets my
given criteria specification, rather select the range A1:B5. is there any
way to this

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
Exact Precedents	Abdul Shakeel	Excel Worksheet Functions	8	July 23rd 08 04:55 AM
Tracing precedents	johnston	Excel Worksheet Functions	0	May 18th 07 12:21 PM
Formula Precedents	Brendan Vassallo	Excel Discussion (Misc queries)	2	September 11th 06 12:09 AM
Excel Precedents	Joshua Bright	Excel Discussion (Misc queries)	1	July 28th 05 06:22 PM
Precedents do not work	Paula	Excel Worksheet Functions	1	March 30th 05 08:40 PM

All times are GMT +1. The time now is 07:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us