software

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=quot;Cashierquot;,IF(A5:A104=quot;Cquot;,1,0)))

Thanks,
Mark
Contrl shift Enter keys

quot;mmockquot; wrote:

gt; I while back osmeone helped me with this formula. I needed to add another
gt; column and the same forumla but with different cells. I remember at the end
gt; of the formula I was to do a shift/control F-Something to get the { } on the
gt; outside of the formula. Can I get some assistance as to what the combination
gt; was to get this formula to work?
gt;
gt; =SUM(IF(E5:E104=quot;Cashierquot;,IF(A5:A104=quot;Cquot;,1,0)))
gt;
gt; Thanks,
gt; Mark
gt;
gt;
gt;
gt;

as the other poster suggested the command is ctrl shift enter to enter an
array formula. However, you can replace it with the following formula that
is not an array formula. I personally hate array formulas and avoid them
when I can, but it's really a matter of preference.

=SUMPRODUCT((E5:E104=quot;Cashierquot;)*(A5:A104=quot;Cquot;))

quot;mmockquot; wrote:

gt; I while back osmeone helped me with this formula. I needed to add another
gt; column and the same forumla but with different cells. I remember at the end
gt; of the formula I was to do a shift/control F-Something to get the { } on the
gt; outside of the formula. Can I get some assistance as to what the combination
gt; was to get this formula to work?
gt;
gt; =SUM(IF(E5:E104=quot;Cashierquot;,IF(A5:A104=quot;Cquot;,1,0)))
gt;
gt; Thanks,
gt; Mark
gt;
gt;
gt;
gt;

yes, that was it thank you!

quot;N Harkawatquot; wrote:

gt;
gt; Contrl shift Enter keys
gt;
gt; quot;mmockquot; wrote:
gt;
gt; gt; I while back osmeone helped me with this formula. I needed to add another
gt; gt; column and the same forumla but with different cells. I remember at the end
gt; gt; of the formula I was to do a shift/control F-Something to get the { } on the
gt; gt; outside of the formula. Can I get some assistance as to what the combination
gt; gt; was to get this formula to work?
gt; gt;
gt; gt; =SUM(IF(E5:E104=quot;Cashierquot;,IF(A5:A104=quot;Cquot;,1,0)))
gt; gt;
gt; gt; Thanks,
gt; gt; Mark
gt; gt;
gt; gt;
gt; gt;
gt; gt;

Thank you so much....this is much better than the array formula way. I can
always get the correct answer and more here......thank you!

quot;Slothquot; wrote:

gt; as the other poster suggested the command is ctrl shift enter to enter an
gt; array formula. However, you can replace it with the following formula that
gt; is not an array formula. I personally hate array formulas and avoid them
gt; when I can, but it's really a matter of preference.
gt;
gt; =SUMPRODUCT((E5:E104=quot;Cashierquot;)*(A5:A104=quot;Cquot;))
gt;
gt; quot;mmockquot; wrote:
gt;
gt; gt; I while back osmeone helped me with this formula. I needed to add another
gt; gt; column and the same forumla but with different cells. I remember at the end
gt; gt; of the formula I was to do a shift/control F-Something to get the { } on the
gt; gt; outside of the formula. Can I get some assistance as to what the combination
gt; gt; was to get this formula to work?
gt; gt;
gt; gt; =SUM(IF(E5:E104=quot;Cashierquot;,IF(A5:A104=quot;Cquot;,1,0)))
gt; gt;
gt; gt; Thanks,
gt; gt; Mark
gt; gt;
gt; gt;
gt; gt;
gt; gt;