Substitute for averageifs
Hi, I'm looking for a substitute for the averageifs formula, as it's only
supported in Excel 2007 and I'd like my spreadsheet to be compatible with at least excel 2003. Do anyone know a substitution for this? =AVERAGEIFS(I2:I12,I2:I12,"0",D2:D12,"=OV") thanks for the help! -- Jordan |
Substitute for averageifs
=AVERAGE(IF((D2:D12="OV")*(I2:I120),I2:I12))
entered with ctrl + shift & enter -- Regards, Peo Sjoblom "Jordan" wrote in message ... Hi, I'm looking for a substitute for the averageifs formula, as it's only supported in Excel 2007 and I'd like my spreadsheet to be compatible with at least excel 2003. Do anyone know a substitution for this? =AVERAGEIFS(I2:I12,I2:I12,"0",D2:D12,"=OV") thanks for the help! -- Jordan |
Substitute for averageifs
Thanks for the help! :o)
-- Jordan "Peo Sjoblom" wrote: =AVERAGE(IF((D2:D12="OV")*(I2:I120),I2:I12)) entered with ctrl + shift & enter -- Regards, Peo Sjoblom "Jordan" wrote in message ... Hi, I'm looking for a substitute for the averageifs formula, as it's only supported in Excel 2007 and I'd like my spreadsheet to be compatible with at least excel 2003. Do anyone know a substitution for this? =AVERAGEIFS(I2:I12,I2:I12,"0",D2:D12,"=OV") thanks for the help! -- Jordan |
All times are GMT +1. The time now is 08:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com