I have a table with the headings
Status | Currency | Total
In the rows I have a variation of statuses and currencies.
Using Google Spreadsheet I added this:
in the hope calculating the total sum of those rows which are COMPLETE and GBP
The error I get is
#VALUE! Range has no entry corresponding to this cell
Can anyone help please?