11 On the June2015 worksheet , in cell I7 , sum the values
9 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 .
12 On the June2015 worksheet , in cell I11 , calculate the
9 total amount spent on groceries using a credit card ; in cell I12 , calculate the average spent on groceries using a credit card ; in cell I13 , calculate the number of times groceries were purchased using a credit card during the month .
13 On the June2015 worksheet , in cell F7 , nest an AND
6 function within an IF function to determine if the transaction was paid using a credit card and the amount of the transaction is less than -100 . If both conditions are met in the AND function , the function should return the text Flag . For all others , the function should return the text OK . Copy the function down through cell F24 .