Does anyone know how to do an NPV over multiple rows without having to sum
the columns. eg
Y1 Y2 Y3
NHU1 -100 100 100 etc
NHU1 -150 200 300 etc
NHU2 -160 140 300 etc
NHU2 -200 180 120 etc

Complete NPV by looking for NHU , summing each year for the NHU over
multiple rows. Obvious way is to total each NHU them NPV the total, or NPV
each row and sumif NPV's, but I dont want to include totals or NPVs in this
worksheet as its a data sheet.

Thanks