Automating adding up a column
 

Hi,

I have an issue regarding adding up seconds in a column but for only certain
records. The severity column is W and the seconds column is V. Basically I
would need to add up all the seconds for a certain criteria if found in
column W.

Completely stuck - please help!
Thanks

Automating adding up a column
 

=SUMIF(W:W,10,v:V)

where 10 is the test criteria in my example

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nicki King" wrote in message
...
Hi,

I have an issue regarding adding up seconds in a column but for only
certain
records. The severity column is W and the seconds column is V. Basically
I
would need to add up all the seconds for a certain criteria if found in
column W.

Completely stuck - please help!
Thanks

Automating adding up a column
 

Bob

Thanks, that was very helpful. OK the next question is on how to expand
that. If I then had to add up the numbers in Col V by criteria set in W and
also in X - would sumif be the one to use or something else?

"Bob Phillips" wrote:

=SUMIF(W:W,10,v:V)

where 10 is the test criteria in my example

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nicki King" wrote in message
...
Hi,

I have an issue regarding adding up seconds in a column but for only
certain
records. The severity column is W and the seconds column is V. Basically
I
would need to add up all the seconds for a certain criteria if found in
column W.

Completely stuck - please help!
Thanks