| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
please help how to combine IF function with Countif function
Hi,
When I enter the formula which is at the end, I get the result of 3 in Col B, row 2 instead of 2. Category New Term A 2 B C D E F New A New A New B Term B Term E New F Term D Term C Term C New F New B Term A {=IF($C$13:$C$24="new",COUNTIF($D$13:$D$24,"A"))} Thank you for taking time to solve the formula. Dinesh |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
please help how to combine IF function with Countif function
Hi!
Try this: =SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A")) Biff "Dinesh" wrote in message ... Hi, When I enter the formula which is at the end, I get the result of 3 in Col B, row 2 instead of 2. Category New Term A 2 B C D E F New A New A New B Term B Term E New F Term D Term C Term C New F New B Term A {=IF($C$13:$C$24="new",COUNTIF($D$13:$D$24,"A"))} Thank you for taking time to solve the formula. Dinesh |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
please help how to combine IF function with Countif function
What if I want to add the values which is on Col E,rows 13 to 24. I tried
putting =sum(e13:e24),if(sumproduct(--($C$13:$C$24="new"),--($D$13:$D$24="A")) It didn't work. Thanks in advance. "Biff" wrote: Hi! Try this: =SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A")) Biff "Dinesh" wrote in message ... Hi, When I enter the formula which is at the end, I get the result of 3 in Col B, row 2 instead of 2. Category New Term A 2 B C D E F New A New A New B Term B Term E New F Term D Term C Term C New F New B Term A {=IF($C$13:$C$24="new",COUNTIF($D$13:$D$24,"A"))} Thank you for taking time to solve the formula. Dinesh |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
please help how to combine IF function with Countif function
Try this:
=SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A"),$E$13:$E$24) Biff "Dinesh" wrote in message ... What if I want to add the values which is on Col E,rows 13 to 24. I tried putting =sum(e13:e24),if(sumproduct(--($C$13:$C$24="new"),--($D$13:$D$24="A")) It didn't work. Thanks in advance. "Biff" wrote: Hi! Try this: =SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A")) Biff "Dinesh" wrote in message ... Hi, When I enter the formula which is at the end, I get the result of 3 in Col B, row 2 instead of 2. Category New Term A 2 B C D E F New A New A New B Term B Term E New F Term D Term C Term C New F New B Term A {=IF($C$13:$C$24="new",COUNTIF($D$13:$D$24,"A"))} Thank you for taking time to solve the formula. Dinesh |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
please help how to combine IF function with Countif function
Thanks Biff.
"Biff" wrote: Try this: =SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A"),$E$13:$E$24) Biff "Dinesh" wrote in message ... What if I want to add the values which is on Col E,rows 13 to 24. I tried putting =sum(e13:e24),if(sumproduct(--($C$13:$C$24="new"),--($D$13:$D$24="A")) It didn't work. Thanks in advance. "Biff" wrote: Hi! Try this: =SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A")) Biff "Dinesh" wrote in message ... Hi, When I enter the formula which is at the end, I get the result of 3 in Col B, row 2 instead of 2. Category New Term A 2 B C D E F New A New A New B Term B Term E New F Term D Term C Term C New F New B Term A {=IF($C$13:$C$24="new",COUNTIF($D$13:$D$24,"A"))} Thank you for taking time to solve the formula. Dinesh |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
please help how to combine IF function with Countif function
You're welcome!
Biff "Dinesh" wrote in message ... Thanks Biff. "Biff" wrote: Try this: =SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A"),$E$13:$E$24) Biff "Dinesh" wrote in message ... What if I want to add the values which is on Col E,rows 13 to 24. I tried putting =sum(e13:e24),if(sumproduct(--($C$13:$C$24="new"),--($D$13:$D$24="A")) It didn't work. Thanks in advance. "Biff" wrote: Hi! Try this: =SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A")) Biff "Dinesh" wrote in message ... Hi, When I enter the formula which is at the end, I get the result of 3 in Col B, row 2 instead of 2. Category New Term A 2 B C D E F New A New A New B Term B Term E New F Term D Term C Term C New F New B Term A {=IF($C$13:$C$24="new",COUNTIF($D$13:$D$24,"A"))} Thank you for taking time to solve the formula. Dinesh |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
please help how to combine IF function with Countif function
thanks. it works.
"Dinesh" wrote: Hi, When I enter the formula which is at the end, I get the result of 3 in Col B, row 2 instead of 2. Category New Term A 2 B C D E F New A New A New B Term B Term E New F Term D Term C Term C New F New B Term A {=IF($C$13:$C$24="new",COUNTIF($D$13:$D$24,"A"))} Thank you for taking time to solve the formula. Dinesh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| Combine two or more columns by using a function | Excel Discussion (Misc queries) | |||
| IF Function or Countif | Excel Worksheet Functions | |||
| COUNTIF FUNCTION | Excel Worksheet Functions | |||
| hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions | |||
Hybrid Mode
