Dotan Cohen said the following on 12/17/2009 2:10 PM: > I apologize for all the questions, but I have been going at this all > day and these are the areas where I am getting stuck. > > I have a column (Column A) with dates in the mm/dd/yyyy format, a > column with a text format (Column B), and a column with the HH:MM:SS > time format (Column C). I need to add up all the values of Column C > for which their corrosponding row meets both these criteria: > 1) The month is a specific month (for example, Column A is xx/08/xxxx) > -and- > 2) The text field is a specific value (for example, Column B="viscoplastic") > > I am getting into nested functions and getting very lost. Any help > would be appreciated. Thanks. > What about an extra column that lists the month number of column A and a pivot table on that column and column B with a SUM of column C. With filtering you can select with texts of column of B you like to see.
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
