=SUM(b4:b6) If it doesn't show the $ sign just make sure it's in currency :) I hope this helped!! Good Luck!!! :)
Unless you specify otherwise, excel summarizes data by summing numeric data and counting data fields containing text.
<span> The most commonly used ways to </span><span>summarize data in excel are: pivot tables, autosum, sort, selection....
</span>