Data Analysis Spreadsheet Basics Getting Started With Spreadsheets Getting Started With Spreadsheets Review

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.

4 Answers

Steven Parker
Steven Parker
153,143 Points

I got a significantly smaller value. What formula did you use?

I did: =SUM(B5:B176), was it looking for the sum of F&B and Entertainment?

Steven Parker
Steven Parker
153,143 Points

So "SUM" isn't going to do the filtering you need. You'll probably need "SUMIF".

i just got the right answer, strangely I don't think I did anything else. Thanks for looking at this for me

Steven Parker
Steven Parker
153,143 Points

Without "SUMIF"? What was the formula that gave you the correct value?

Candace Steinebach
Candace Steinebach
4,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.