Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating multiple scenarios | Excel Discussion (Misc queries) | |||
IF statement - multiple scenarios | Excel Worksheet Functions | |||
IF statement with multiple scenarios. | Excel Discussion (Misc queries) | |||
How to do if/then formula with multiple scenarios. | Excel Discussion (Misc queries) | |||
Return multiple scenarios | Excel Worksheet Functions |