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
|