On Thursday 17 December 2009 18:40:11 Dotan Cohen wrote:
> 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.
>
Brian,
In addition to (and not taking away the value from) the Spreadsheet
sent by Brian McKee (brian dot mckee at gmail dot com) you may want to
check this formula out :
{=sum(if(month(A1:A100)=8;if(B1:B100="viscoplastic";C1:C100;0);0))}
where the "{" and "}" are inserted by Shift Control Enter
and the above formula is in a cell that is formatted the same as
Column C (hh:mm:ss)
Change the range to what ever is appropriate for you.
As usual, YMMV.
Hope this helps.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
