Hi

I have three rows that have totals across 5 cells example say

Total using cells c14:G14
Roster using c15:g15
Forecast using c16:g16

and if the totals were
C D E F G
row 14 16 1 0 5 3
row 15 14 13 1 2 13
row 16 40 35 32 30 40

I would like another cell to count so that if
row 14 is =16
row 15 is =13
row16 is = 40

It would calculate then only show total (using example would equal 5)

Thanks

Lise