For this question in the test "In the Expenses spreadsheet you opened in the first question, the total dollar value of a
For this question on the test: "In the Expenses spreadsheet you opened in the first question, the total dollar value of all items in the F&B and Entertainment categories is:" I get the answer $9431. I genuinely am not sure why this is not the correct answer.
I did: =SUM(B5:B176), was it looking for the sum of F&B and Entertainment?
i just got the right answer, strangely I don't think I did anything else. Thanks for looking at this for me
Candace Steinebach4,725 Points
You will want to use the sumif formula along with the absolute value concept you learned. =sumif(range,criterion,sumrange)
Remember that absolute value uses the $ symbol.
I hope this help.