LinkBack URL
About LinkBacks
this will work for the 1st part...
=AVERAGEIFS(B1:B9,A1:A9,">="&8/24,A1:A9,"<="&20/24)
Tring to figure out why the opposite wont work...
=AVERAGEIFS(B1:B9,A1:A9,"<"&8/24,A1:A9,">"&20/24)
gives #DIV/0
this will work for the 1st part...
=AVERAGEIFS(B1:B9,A1:A9,">="&8/24,A1:A9,"<="&20/24)
Tring to figure out why the opposite wont work...
=AVERAGEIFS(B1:B9,A1:A9,"<"&8/24,A1:A9,">"&20/24)
gives #DIV/0
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks