Step 22 of 40: Collections By Month with SUMIF Step 12.300 we OUTLI Seard B 1 Ways Widgets January February March April May 25 Collections January 3 Budgeted Sales in Dollars 30,000 120,000 123,000 126.000 129,000 26 January Sales Commissions in Dollars 12,000 12,600 12,900 27 SUMIF($B$25:$M$25,5A26,58$8:$M$S312 30 2 C 11 Collection May 2L Keyboard shortcut: Press Cmd-T to create absolute 12 January 30 Update the formula to multiply references after selecting a range of cells. Press Cmd-T 13 February 25% 31 the SUMIF result by cell B12. again as needed to create a mixed reference. 14 March SON 32 15 April 25% 33 August 16 May 34 September =SUMIF($B$25:$M$25,$A26,$B$8:$M$8) M range criteria sum_range 3 Walys Wide Nome December $B$25:$M$25 $A26 $B$8:$M$8 YOUR TURN: Copy the formula Where to look, the month what to look for, in this the cells to sum, the from cell B26 to cells B26:M3. The names on row 25 case the month in cell A26 Sales Amounts on row 8 formula will not work correctly if you omitted any in the formula 25 Collections Lanuary February March April May 26 January 120.000 35 October 73500 36750 36 November 37500 75000 23 -SUMUR(18525:3M525,8425,5058,5158) Enter this formula 27 December 38250 29 AD 38 che Cash Budget Inputs Supporting Schedules Students Excel Formatting as Table Styles v fx SUMIF$B$25:$M$25,SA26,58$8:$M$8)*812 E H D March January April May June fuly November tory in Units Dos GOOD 10150 February 6150 10400 M December 7650 12750 6303 10650 6450 10900 6600 11150 August September October 6900 7050 7200 7350 11650 11900 12150 12400 6750 11400 7500 12550 130000 125000 126000 129000 132000 135000 138000 141000 144000 147000 Onlar 150000 153000 February March 15 SON Aril May June sos 25% July 25 August 25% September SOX 25 October 25% November December SON M Art My July A September October November December 15 An May une July AL aputs Supporting Schedules November December Order of an