Automating adding up a column

N

Nicki King

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
 
B

Bob Phillips

=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)
 
N

Nicki King

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?
 
Top