Thread: How do I insert a ' } ' into excel so that I can adjust its size?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How do I insert a ' } ' into excel so that I can adjust its size?
I suspect you are referring to an Array formula.

A simple array formula would be:-

=Sum(IF($A$1:$A$10="Widgets",$B$1:$B$10))
when typed in you enter it by pressing
Ctrl+Shift+Enter and the curly brackets appear.

Mike


"deepstevec" wrote:

How do I insert a ' } ' so that I can adjust its size to incorporate a number
of excel rows?
Reply With QuoteReply With Quote