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

Check out help on
=SUMIF()

If this post helps click Yes
---------------
Jacob Skaria


"Pinehurst" wrote:

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

Try this:

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

Format as [h]:mm

--
Biff
Microsoft Excel MVP


"Pinehurst" wrote in message
...
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

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)

"Pinehurst" wrote:

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

Maybe =sumif() will work ok:

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



Pinehurst wrote:

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

--

Dave Peterson