The below seems to be a standard example for Excel 2000. I have seen it in a number of places.
--
To calculate the total value of cells F5:F25, where B5:B25 contains either "Northwind" or "Terra Firm", use the following formula.
=SUM(IF((B5:B25="Northwind")+(B5:B25="Terra Firm"),F5:F25))
--
Yet when I try this out I get a #VALUE! error.
Any ideas what's wrong?
--
To calculate the total value of cells F5:F25, where B5:B25 contains either "Northwind" or "Terra Firm", use the following formula.
=SUM(IF((B5:B25="Northwind")+(B5:B25="Terra Firm"),F5:F25))
--
Yet when I try this out I get a #VALUE! error.
Any ideas what's wrong?