Question
on the june2017 worksheet, in cell I7,sum the values in E7:E24 if the purchase in column C is groceries; in cell I8, average the values in E7:E24 if the purchase in column C is groceries; in cell I9, calculate the number of times groceries were purchased during the month
exploring.ecap.grader.c2_Transactions, LastFirst. Excel Tell me what you want to do. - File Home Insert Page Layout Data Review View ACROBAT G) Manager 18-Trace Precedents Define Name Use in fermulia Create from Selection . Show Formulas insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name , 60Calculate Now Watch Calculation Calculate Sheet Window Options . Time-Reference . Tng . Functions Remove Arrows Evaluate Formula · Function Library Defined Names Formula Auditing 17 Search Results Position Amount: Cat Method of Payment Amount Groceries 6/1/2017 Zachary Kaye 6/4/2017 Visa 6/8/2017 South & Main 6/8/2017 Income 6/8/2017 [Savings Account Total Cost: Average Cost: Occurrences: Credit Card Payment Check ATM Withdrawal Debit Card Salary Transfer to Savings Transfer Electric Bill Student Loan Gas Water Bill ATM WithdrawalDebit Card Salary Transfer to Savings Transfer 2034.78 Groceries Credit Card Total Cost Average Cost: Occurrences: 2 6/15/2017 SEC 217.61 6/15/2017 Springfield Savings & Loans 14 6/18/2017 Gas-N-Wash 15 | 6/18/2017 SGw 16 6/22/2017 South & Main 17 6/22/2017 Income Credit Card 43.59 Average Credit 2034.78 6/22/2017 [Savings Account] 9 6/23/2017 George's SuperMart 20 6/25/2017 CIv Solutions 21 6/25/2017 Springfield Savings & Loans Car Loan 22 6/28/2017 AMP Insurance 23 6/29/2017 Sam's Stop 24 6/30/2017 George's SuperMar Credit Card 109.64 102.83 Total Remaining: Cable/Internet Check 96.47 -60.08 149.68 Payment Credit Card Options:Debit Card Car Insurance Debit Card Debit Card Transfer Category Method of Payment Credit Card Amount JuneTotals June2017 AnnualExp Homeloan |Carloan Stocks Ready
Explanation / Answer
After doing the calculation in Excel, you will get the following answers :
Total cost (Cell I7) = -259.32 [done using the formula =SUMIF(C7:C24,"Groceries",E7:E24)]
Average Cost of Groceries(cell I8) = -129.68 [ formula =SUMIF(C7:C24,"Groceries",E7:E24)/COUNTIF(C7:C24,"Groceries")]
No. of times Groceries were purchased during the month(Cell I9) = 2 [formula =COUNTIF(C7:C24,"Groceries")]
