for row 14
=COUNTIF(A14:E14,"=16")

for row 15
=COUNTIF(A15:E15,"=13")

for row 16
=COUNTIF(A16:E16,"=40")



On Jan 19, 10:52*am, Lise wrote:
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