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