Selected Answer

You can solve your problem with the use of the SUMIFS function, for example as shown below.

`=SUMIFS([Sum range],[1st Criteria range],[Criterium],[2nd Criteria range],[2nd Criterium], etc, etc)*12`

`[K2] =SUMIFS(F:F,H:H,H2,I:I,I2,J:J,J2)*12`

This formula returns the correct results for the 6 examples in your sample but I couldn't quite figure out which are the relevant criteria. Perhaps the End Date isn't, and perhaps the Currency is. You may have to adjust the formula.

The formula will return the same result for each group of rows. For example, if you copy it from Rows(2) (for which it is designed) down to Rows(4) all cells will show the same result. There is no easy way to avoid this. Therefore you would need to work on the results.

If you need a total in the column the extra values have to be eliminated. One way to achieve this would be with a helper column. Paste the formula below in the helper columns Row #2 and copy down. Change the referenced column (here column K) as required.The column can be totalled using the SUM function.

`=IF(K2<>K1, K2,"")`

If you don't need a total, just for visual effect you could hide the superfluous results using conditional formatting and the same logic. Use the formula below to determine the cells to format and format their font colour to turn white (colour of the background) so that the number becomes invisible.

`=K2=K1`

One easy way to apply this format is to select all cells to which the format is to apply, e.g. K2:K1700, and type the formula so that the first referenced cell is the active cell (that is the first cell of the range you selected) and the second one the cell above it. You can later adjust the range in the CF Manager by changes the *Applies To* range address.