Thanks Muddan - I did that but added * as follows as I want one cell to count
three scenarios but its not counting them??

=COUNTIF(C14:I14,"=16")*COUNTIF(C13:I15,"=13")*C OUNTIF(C16:I16,"=40")
--
Thanks

Lise


"muddan madhu" wrote:

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