To sum the numbers in A10:G10 when some of the cells could have text or
error codes such as #N/A, use
=SUM(IF(ISNUMBER(A10:G10),A10:G10,0))
but since this is an array formula, commit it with SHIFT+CTRL+ENTER not just
ENTER
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shafaq Shabieh" wrote in message
...
In an excel sheet, i have gathered the data for sales, redemption and Net
sales of all the mutual funds for the period of October. The excell sheet
depicts the daily sales, redemption & Net sales of each fund. So there are
27
columns for sales numbers, 27 for redemptions, and 27 for Net sales
(excluding sundays from the month). most of the cells contain numbers
while
some cells do contain "N/A" in order to highlight that there was no sale
on
that specific day due to book closure. now i want to add the total sales,
redemptions and net sales of each fund for the whole month. i can not add
the
numbers by supplying range, i have to click specific cells in order to get
the grand total.
The format below shows how values are entered into the excel:
A B C D E F G X Y
Z
FUND OCT 4 Oct 6 ...... Oct 31
Total (Oct)
Name Sales Red Net-Sal Sales Red Net-Sal Sal Red Net-Sal Sales
Red
Net-Sal
ABC 23 45 -22 N/A 35 12 23
(A, B, C, D, E .... Z = COLUMNS)

please, let me know if there is any way i can sum the total
sales/redemptions/net sales.
i have Ms Excel 2007, Vista.
Thank you
--
Shafaq