wew.PNG
how do i get the average DURATION of those that have value as 0 in LINES.
and how do i get the average duration for those that have values in lines?
please help
wew.PNG
how do i get the average DURATION of those that have value as 0 in LINES.
and how do i get the average duration for those that have values in lines?
please help
Hello and welcome to the forum.
Try the AVERAGEIF function.
Something like this:
=AVERAGEIF(G:G,0,I:I)
and
=AVERAGEIF(G:G,">0",I:I)
Thank you so much sir it works so well
You're welcome. Happy to help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks