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

David Griffith
David Griffith
8,298 Points

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
119,883 Points

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

David Griffith
David Griffith
8,298 Points

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

Steven Parker
Steven Parker
119,883 Points

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

David Griffith
David Griffith
8,298 Points

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
119,883 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.