How this function is read?
Hi everyone,
I have this Excel function: =AVERAGE(IF(D$7:D$31=D14,E$7:E$31,"")) What does it mean? Or, how it can be read? Thanks, Mike |
How this function is read?
This is an array formula so it must be entered/edited with ctrl+shift+enter
it will average numbers in E for only those items in D that match d14 -- Don Guillett SalesAid Software "Mike" wrote in message ups.com... Hi everyone, I have this Excel function: =AVERAGE(IF(D$7:D$31=D14,E$7:E$31,"")) What does it mean? Or, how it can be read? Thanks, Mike |
How this function is read?
It says
Take the average of the cells in E7:E31 only where the equivalent cell within D7:D31 is equal to the cell D14. In simple terms, it allows conditional AVERAGE, MAX MIN etc, equivalent to (the non-existent) AVERAGEIF -- HTH RP (remove nothere from the email address if mailing direct) "Mike" wrote in message ups.com... Hi everyone, I have this Excel function: =AVERAGE(IF(D$7:D$31=D14,E$7:E$31,"")) What does it mean? Or, how it can be read? Thanks, Mike |
All times are GMT +1. The time now is 12:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com