Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Avg Times in MOD fx using selected rows


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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dav Dav is offline
external usenet poster
 
Posts: 1
Default Avg Times in MOD fx using selected rows


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

Regards

Dav


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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default Avg Times in MOD fx using selected rows

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

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I invoke running a macro from within an "IF" function. ron Excel Worksheet Functions 11 February 8th 06 04:35 PM
concatenating rows from different sheets ExcelWolfie Excel Worksheet Functions 1 January 27th 06 06:31 PM
how many rows did I selected Paul Ho Excel Worksheet Functions 1 November 26th 05 07:59 AM
Finding minimum value across selected rows of an array Dazed and confused about min, max Excel Worksheet Functions 2 February 26th 05 12:11 AM
Row selections by row # OR by even/odd rows in another spreadsheet Tom Excel Discussion (Misc queries) 0 February 9th 05 05:03 PM


All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"