I have a question in regards to averaging times. I am using the "MOD"
fx due to having times that will go past 12mid (utilizing military
times). I am finding the difference between the two times in two
separate columns and returning a value in minutes in a third column.
This seems to be working correctly.

Now, with that, I would like to only choose certain rows with those
times that are represented by a constant factor and then average the
times from the above difference.

I have used a "SUMIF" fx and added to that a "+AVERAGE" fx but the
value is not the correct average.

Is there another way? Or am I doing it completely wrong?

PLEASE HELP!!!


--
vldavis809
------------------------------------------------------------------------
vldavis809's Profile: http://www.excelforum.com/member.php...o&userid=36146
View this thread: http://www.excelforum.com/showthread...hreadid=559200

If your sumif works correctly to return a total, use the same criteri
on a countif. then for the average =sumif function/countif function

Regards

Da

--
Da
-----------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...fo&userid=2710
View this thread: http://www.excelforum.com/showthread.php?threadid=55920

Try

=AVERAGE(IF(rng_to_test=criteria,rng_to_average))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vldavis809" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> I have a question in regards to averaging times. I am using the "MOD"
> fx due to having times that will go past 12mid (utilizing military
> times). I am finding the difference between the two times in two
> separate columns and returning a value in minutes in a third column.
> This seems to be working correctly.
>
> Now, with that, I would like to only choose certain rows with those
> times that are represented by a constant factor and then average the
> times from the above difference.
>
> I have used a "SUMIF" fx and added to that a "+AVERAGE" fx but the
> value is not the correct average.
>
> Is there another way? Or am I doing it completely wrong?
>
> PLEASE HELP!!!
>
>
> --
> vldavis809
> ------------------------------------------------------------------------
> vldavis809's Profile:
http://www.excelforum.com/member.php...o&userid=36146
> View this thread: http://www.excelforum.com/showthread...hreadid=559200
>