Count using multiple scenarios
 

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

Count using multiple scenarios
 

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

Count using multiple scenarios
 

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

Count using multiple scenarios
 

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")+C OUNTIF
(C16:I16,"=40")


On Jan 20, 2:37*am, Lise wrote:
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

Count using multiple scenarios
 

Excellent - thanks Muddan
--
Kind Regards

Lise


"muddan madhu" wrote:

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")+C OUNTIF
(C16:I16,"=40")


On Jan 20, 2:37 am, Lise wrote:
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