Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula missing something
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula missing something
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="Cashier")*(A5:A104="C")) "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula missing something
yes, that was it thank you!
"N Harkawat" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula missing something
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! "Sloth" wrote: 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="Cashier")*(A5:A104="C")) "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) |