Question: what formula is used to calculate total revenue in excel?
Answer: Enter "=SUM(D1:D#)" in the next empty cell in column D. Replace "#" with the row number of the last entry in column D. In the example, enter "=SUM(D1:D2)" to calculate the total sales revenue for the two items.