Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |