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