Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
dear all,
thanks in advance for ur help.. i have an excel sheet (monthly) that displays the daily order for each customer during the whole month. Meaning that, i have in the first column cust name, then i have a column that calculates the total of each month for each customer, and in the remaining columns i have the day's date, under which the number of order placed bu the cust is inserted. For months that have 30 days, the total sum formula works just fine. for months that have 31 days, it gives me the following error: more arguments have been specified for this function than are allowed in the current file format. i copied the file from a month that have 30 days and i added a new column for the 31st day. i tried to insert the field of the 31st day in the function manually. this is where i received the error. any idea? -- Croco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I use IF function in calculated fields in a pivot table? | Excel Worksheet Functions | |||
Help Please! - Creating Function Calculated Fields within Pivot Tables | Excel Worksheet Functions | |||
Changing other fields using IF Function!? | Excel Worksheet Functions | |||
function to show if two fields in a column have the same data. | Excel Worksheet Functions | |||
Sum function on multiple date fields | Excel Worksheet Functions |