I am currently using the below formula to calculate enablement costs for meters

```
=SUM(SUMIF($D74,{"New Business"}),$U74*5500)
```

This worked fine as the fee of $5500 was standard, however I now need to incorporate a new cost for a specific meter. The NZ meter is $13000. In column F the classification is NZ Instant Reserve.

How do I maintain the above formula for the rest of my spreadsheet, but add the additional IF check for the specific meter (which only account for about 10% of my whole list).

`SUMIF($D74,{"New Business"})`

always returns zero (no matter what value you have in D74) so your whole formula as written here can be shortened to`=U74*5500`

- do you expect the result of the formula to change based on what's in D74? It won't. Either you have quoted the wrong formula here or possibly the formula will give you results you don't expect - please explain in words what the formula should do? – barry houdini Mar 21 '13 at 14:13