HOW CAN I IMPLEMENT SUMIF(D1:D6,">AVERAGE(D1:D6)")

B

bapeltzer

Move the average function out of the quotes; while there it's being treated
as part of the text string rather than being evaluated:
=sumif(d1:d6,">" & average(d1:d6))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumifs, averageifs, countifs 6
Calculating column A * column B = Results in another column 2
Take an average of data where lookup in array is needed 3
Conditional Time Calculation 10
Merging cells and formats 8
Array reference 3
How to implement two shifts per day with multiple teams 0
Learning arrays. 13

Top