averageifs on multiple tables/ranges

I want to use the averageif or averageifs function to average the times based on the task. From this view: Task 1 average is 0:10, Task 2 is 0:13.5, etc

excel.jpg

I've tried several solutions with no success, please help!

Hi kpkammer,

Welcome to the forum.

Please post the excel workbook, not the images as it become little lengthy to see image and provide excel resolution. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Kpkammer,

From this view: Task 1 average is 0:10

I am getting Task 1 average as 1:43:23... see the attachment and take the average of yellow cells..
which cells you are considering for Task 1?

Usability Testing Data.xls

Regards,
DILIPandey

<click on below 'star' if this helps>

@kvsrinivasamurthy, given the repetitive layout and distinct data types you can in fact use a single range:

Please Login or Register  to view this content.

or, in 2003 (pre AVERAGEIF(s)) you could use single SUMIF/COUNTIF

Originally Posted by kpkammer

That doesn't help me. I have multiple tables/ranges I need to average over.

kpkammer, see attached (based on your sample data)

Fundamental point being that where your "multiple ranges" follow a pattern (data type and layout) then you do not need to treat each separately, the nature of the functions you're using will handle the data appropriately.