Countif and suming a time

[Pinehurst]

I have a spreadsheet with a couple of couluns that contain decriptive text
of tasks driven by drop downs, and a column that contains time spenyt on a
task.

I use countif to find out how many times a specific task was done, but I now
must also work out how much time is spent doing that task.
Any help please

 

[Jacob Skaria]

Check out help on
=SUMIF()

If this post helps click Yes

 

[T. Valko]

Try this:

=SUMIF(A1:A10,"task",B1:B10)

Format as [h]:mm

 

[PhilosophersSage]

I use sumif with countif
=COUNT(F737:F949)
=SUMIF(F737:F949, ">0", E737:E949) this tests to see if a value is greater
then zero, remember you need doubble quotes arount your test in this function.
Remember that you use your test range, then if statment and then your sum
range.
=SUMIF(TEST REANGE, TEST, SUM RANGE)

 

[Dave Peterson]

Maybe =sumif() will work ok:

=sumif(a:a,"description",b:b)