#value! on spreadsheet when formula palette gets correct result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=AVERAGE(IF(C5:C14="Europe",D5:D14)), an example in the help, gives correct
result within the palette formula editor, but the #value! is all that shows
up in the spreadsheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex Formula question 9
Average cells based on column header 6
Stripe out duplicate data 5
Where to put quotes in a SUMIF formula and when is & used for cell 2
Error when using the SUMXMY2 function 1
Using one cells formula in multiple other cells 1
formula explanation 3
Array 9

Back
Top