View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
N Harkawat
 
Posts: n/a
Default formula missing something


Contrl+shift+Enter keys

"mmock" wrote:

I while back osmeone helped me with this formula. I needed to add another
column and the same forumla but with different cells. I remember at the end
of the formula I was to do a shift/control F-Something to get the { } on the
outside of the formula. Can I get some assistance as to what the combination
was to get this formula to work?

=SUM(IF(E5:E104="Cashier",IF(A5:A104="C",1,0)))

Thanks,
Mark