I am getting this error - "#VALUE!" when attempting to perform a function
"=AVERAGE(D3:D4,D6,D8:D11,D13:D14,D27:D29,D39,D41, D47:D49,D51:D53,D56:D60,D62,D68:D69,D71:D72,D74:D7 7,D84:D87,D99,D102,D115,D117:D121,D131:D132,D139,D 144:D163,D164)"

Some of the cells where information is being pulled from is "N/A" and other
cells contain "%" amounts.

Is it possible to complete an total Average function where the information I
am using contains text and number formats and does not create the "#VALUE!"
error? This is in a working spreadsheet where the information changes from
N/A to % often and is unpredictable as to which cell is altered. I would
like a total average that is a number and not an error.

Please help!