Prev: exclude certain cells from series fill
Next: Calculate total metric based on sum of metric over specific time f
From: Bill Friedman on 27 Jan 2010 16:53
The subject says it all; the function does not work for me in Excel 2007.
From: bapeltzer on 27 Jan 2010 16:57
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.
 | 
Pages: 1
Prev: exclude certain cells from series fill
Next: Calculate total metric based on sum of metric over specific time f