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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW CAN I IMPLEMENT SUMIF(D1:D6,"AVERAGE(D1:D6)") (https://www.excelbanter.com/excel-worksheet-functions/254638-how-can-i-implement-sumif-d1-d6-average-d1-d6.html)

Bill Friedman

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

The subject says it all; the function does not work for me in Excel 2007.

bapeltzer

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

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))

"Bill Friedman" wrote:

The subject says it all; the function does not work for me in Excel 2007.

All times are GMT +1. The time now is 08:04 AM.