Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unable to sum the specific cells containing both text & values
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assign values to specific cells in an excel sheet through text file | Excel Discussion (Misc queries) | |||
HELP!!! I am unable to see colored text or highlighted cells ... | Excel Discussion (Misc queries) | |||
Unable to pre-format cells to text when exporting data to csv or x | Excel Discussion (Misc queries) | |||
Summing values in a range against specific text | Excel Discussion (Misc queries) | |||
formatting text on chart for specific values | Charts and Charting in Excel |