Count using multiple scenarios

[Lise]

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

 

[muddan madhu]

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

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

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

 

[Lise]

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")*COUNTIF(C16:I16,">=40")

 

[muddan madhu]

adding multiplication symbol u wont get the result.

In any of the condition gives the result as zero then whole thing will
be termed as zero.

Add '+' symbol instead of '*'.
=COUNTIF(C14:I14,">=16")+COUNTIF(C15:I15,">=13")+COUNTIF
(C16:I16,">=40")

 

[Lise]

Excellent - thanks Muddan
--
Kind Regards

Lise

adding multiplication symbol u wont get the result.

In any of the condition gives the result as zero then whole thing will
be termed as zero.

Add '+' symbol instead of '*'.
=COUNTIF(C14:I14,">=16")+COUNTIF(C15:I15,">=13")+COUNTIF
(C16:I16,">=40")