Hello Forum,
I need to average a column, but only if 2 criteria are met in 2 other columns.
I have attached an example that explains it much better.
Hello Forum,
I need to average a column, but only if 2 criteria are met in 2 other columns.
I have attached an example that explains it much better.
Last edited by sinspawn56; 07-31-2012 at 01:28 PM.
=averageifs(c2:c6,b2:b6,"t",d2:d6,60)
Regards,
Vandan
I did not even see that Averageifs was an option. Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks