For example, suppose I have a table containing month columns (Jan, Feb, … Dec), and the Jun column contains the formula =1.1*[@May]. If I copy that formula to the Jul column, I end up with the same formula (=1.
4. In Total Sales cell H2 used the formula =SUMIF(Salespax,G2,OrderAmt) which the system accepted and converted to =SUMIF(Table1[Salesperson],G2,Table1[Order Amount]). 5. Copied H2 to cells H3 through H8. I’ve tested this by adding and deleting both Salespersons and Order Amount...
As mentioned earlier, array formulas are surrounded with curly brackets. You must not type in these curly brackets (if you do your formula won’t work). They must be entered by pressing CTRL+SHIFT+ENTER when you enter the formula, as opposed to just pressing ENTER. You will notice the cu...