Question: Can someone tell me how i keep getting zero for b26? Resources Presenter Info Side 10.4560 Step 22 of 40: Collections By Month with SUMIF

Can someone tell me how i keep getting zero for b26?  Can someone tell me how i keep getting zero for b26?
Resources Presenter Info Side 10.4560 Step 22 of 40: Collections By Month

Resources Presenter Info Side 10.4560 Step 22 of 40: Collections By Month with SUMIF Step - 10 OUTLIN Search 1 Wallys Widgets January February March April May 2s Collections Lanuary Budgeted Sales in Dollars 120,000 123.000 30.000 126,000 129.000 26 January Sales Commissions in Dollars 12.000 12,300 12,600 12.900 27 SUMIF($B$25:$M$25, 5A26,585&SM 812 2 11 Collection May 2 L 12 anuary Keyboard shortcut: Press Cmd-T to create absolute 11 February references after selecting a range of cells. Press Cmd-T 30 Update the formula to multiply 2596 31 again as needed to create a mixed reference. the SUMIF result by cell B12. 14 March SON 32 15 April 25% 33 August 1 May 34 September =SUMIF($B$25:$M$25,$A26,$B$8:$M$8) M range criteria sum range 3 Waly's Wide November $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 B25 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 Sin the formula 25 Collections Manuary February March April May 120.000 15 October 73500 36750 27. 36 November 37500 25000 - SUMIFS8525 $M$25. SA265858558) Enter this formula 37 December 38250 38 Operating but Cash Bot Supporting Schedule Students 2 or We're here to help. Email us at support studentsexcel.com 00:01/0520 1 D NINE 000 ot OSTS D March 1650 5.450 16 10 150 6.300 NA 30.750 SELE 10.150 0,00 10.00 6.750 17.250 600 11.11 56,500 132.000 11.200 100 18155 5,75 21.400 400 135 000 40 10,000 65.400 12000 11.100 10.00 2 13700 12.300 September 12.000 7250 19350 7,200 12.150 22.000 4.300 11 500 7050 50 6,100 11650 9.00 238.000 11,200 11.30 7.200 18,950 7050 11,00 1.400 14100 October 12,250 500 10.250 7350 12400 20 147.000 14700 3,300 December 12750 7,650 29.400 7.650 12,753 26.500 ISTO 15.100 12.500 2650 20150 750 22 650 75.000 150,000 15.000 huden 10 22.400 14100 1.100 5. ME une M 25 son NIC Semember Otabe Now Dec SON 21 25 SON 35% SC May IT SON AN 50% NSE SON HN SON 2 25 SON 25 13 NOS 24 SON 25 NE 509 A NGE 3 ane luty Sobe October Navender December 20 M 2 30 M 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!