“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

How’s it going? Here I have a table (let’s call it Table 1) that would ordinarily be populated, but I cannot share the values unfortunately. To the far right you can see another little table I used to find the average values for each category and year using AVERAGEIF and also basic formulas for year on year changes (let’s call it Table 2). On Sheet2 is the transposed version of that table (Table 3), which is the one I want to populate using a formula linking it to Table 1 (eliminating the need for Table 2).
I think the formula to use might be HLOOKUP, but I could be wrong… maybe HLOOKUP and AVERAGEIF.
I would really appreciate your help on this. Thanks!

Solved by G. A. in 12 mins

Sum and Average across multiple sheets. I'm quite adequate with excel but can't figures out how to do sumif and averageif across multiple sheets.

Solved by B. W. in 30 mins

Hello, it is difficult to explain my problem without showing you a screenshot, but I am trying to calculate in my "I" column the average social media engagement of various publications appearing in my "F" column. I've created an AVERAGEIF formula (in French however, because my program is in French) based on the Microsoft tutorial on the subject, yet I still get an error message. I can't figure out what is wrong with my forumla. Help!
Thank you.

Solved by Z. U. in 26 mins

Need to average values from cells in column B that correspond to matching criteria in cells in column A. Averageif function returning #DIV/0

Solved by M. F. in 16 mins

I need a formula to average skipping cells with greater than 0 value. Formula: averageif(range,[average_range])

Solved by X. A. in 13 mins

9. Switch to the Employee Summary worksheet and calculate the totals in the table using the appropriate functions.
HINT: Remember that SUMIF adds or totals cells only if they meet the specified criteria, and AVERAGEIF and COUNTIF perform their computations only when the data meets multiple criteria.

Solved by T. C. in 11 mins

Hi,
I have a list of numbers in one column and an condition (0/1) in another column
I want to check the standard deviation only if the condition is 1
I'm using excel 2016 and I did not find an stdevif function similar to averageif but could anyone recommend a clever way in solving my problem?
I've googled and lots of answers are using the CSE equation {=STDEV(IF(B2:B100="Y",A2:A100))}
I did enter the equation using ctrl+shift+enter but what I got is an error: #DIV/0!
...Also, what should I do if I want to compute the SD under more than one columns of conditions (in my file, condition 1 & condition2)?
Thanks.

Solved by B. A. in 28 mins

I do not understand this AverageIF ref. Use the AVERAGEIF function to complete the "Average Hours/Job" column in table 4. Reference the appropriate field in table 1 as your range and the "Difficulty" rating in table 4 as your criteria.

Solved by S. D. in 22 mins

In cell R9, enter a formula using the AVERAGEIF function and structured references to determine the average the number of service years of staff members who have participated in Leadership Training as shown in the Service Years column.

Solved by O. E. in 23 mins

1. Complete the summary information using formulas, and format as shown in Figure 2 below. You must use conditional aggregate functions (COUNTIF, AVERAGEIF, SUMIF) as appropriate in this table. Note: Do not average a set of averages – this produces rounding errors. Use the original data table for overall average.

Solved by O. L. in 13 mins