Comments on: Excel AVERAGEIF function to average cells with condition

Comments page 2. Total comments: 46

1. 

   Kat says:
   2023-03-03 at 12:37 am

   Hi! Hoping you could help me. Im trying to averageifs based on a period of 2 dates. How will the formula go?

   =AVERAGEIFS(survey!D:G,survey!A:A,"="&D4)

   1. 

      Alexander Trifuntov (Ablebits Team) says:
      2023-03-03 at 8:52 am

      Hi!
      Pay attention to the following paragraph of the article above – Using AVERAGEIF with dates and guige: Average if between two values.
      For example:

      =AVERAGEIFS(survey!D:G,survey!A:A,">"&D4, survey!A:A,"<"&D5)

2. 

   Georgia says:
   2023-01-19 at 7:22 pm

   In the table below, I have 8 temperatures for each day of the month and I want to calculate the average of temperatures for the same day:

   year month day temperature Average
   2000 January 1 10
   2000 January 1 20
   2000 January 1 30
   2000 January 1 15
   2000 January 1 32
   2000 January 1 26
   2000 January 1 18
   2000 January 1 23
   2000 January 2 12
   2000 January 2 22
   2000 January 2 34
   2000 January 2 16
   2000 January 2 19
   2000 January 2 26
   2000 January 2 24
   2000 January 2 28
   2000 January 3 18
   2000 January 3 19
   2000 January 3 21
   2000 January 3 22
   2000 January 3 23
   2000 January 3 19
   2000 January 3 20
   2000 January 3 24

   I'm really confused on how to do it.

   1. 

      Alexander Trifuntov (Ablebits Team) says:
      2023-01-20 at 9:21 am

      Hello!
      If I understand your task correctly, try AVERAGEIFS function:

      =AVERAGEIFS($D$2:$D$25,$B$2:$B$25,B2,$C$2:$C$25,C2,$A$2:$A$25,A2)

      Try to enter the following formula in cell E1 and then copy it down along the column. For more information, please visit: Excel AVERAGEIFS function with multiple criteria.

      1. 

         Georgia says:
         2023-01-25 at 6:47 am

         that works! thanks!!

3. 

   C says:
   2022-11-11 at 2:15 pm

   Hello,

   Wondering if you could help me with a query. I have a table detailing: Col A - department, Col B - name, Col C - initial salary, Col D - new salary.
   How do I find out the average salary increase per department using one formula, please? I created a new table, added the unique dept names (col H) and tried the following formula on column I:

   =averageif(A2:1000,H2,D2/C2-1), but it comes up with an error message and it won't work.

   Thank you and kind regards,

   1. 

      Alexander Trifuntov (Ablebits Team) says:
      2022-11-14 at 6:58 am

      Hello!
      If I understand your task correctly, the following formula should help:

      =AVERAGEIF(A1:A10,H1,D1:D10)-AVERAGEIF(A1:A10,H1,C1:C10)

      Please re-check the article above since it covers your task.