Formula for Sheet Summary

MarjorieB

Hi,

Can someone help me with my formula? I'm trying to calculate the savings percentage between the Invoice Amount and Total Spend.

This is the formula I’m using:

=IFERROR(((Invoice Amount-Total Spend £) / Invoice) * 100, 0)

But it doesn't seem to be working correctly. What's wrong with it?

Thank you.

kowal

hi @MarjorieB,

so I assume that: "Invoice Amount-Total Spend £" is name of the column? should not you sum the data from the column first?

invoice is also name of the column? should you not sum this column first ?