software

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.CategoryNewTerm
A2
B
C
D
E
F
NewA
NewA
NewB
TermB
TermE
NewF
TermD
TermC
TermC
NewF
NewB
TermA

{=IF($C$13:$C$24=quot;newquot;,COUNTIF($D$13:$D$24,quot;Aquot;))}

Thank you for taking time to solve the formula.

DineshHi!

Try this:

=SUMPRODUCT(--($C$13:$C$24=quot;newquot;),--($D$13:$D$24=quot;Aquot;))

Biff

quot;Dineshquot; gt; wrote in message
...
gt; Hi,
gt;
gt; When I enter the formula which is at the end, I get the result of 3 in Col
gt; B, row 2 instead of 2.
gt;
gt;
gt; Category New Term
gt; A 2
gt; B
gt; C
gt; D
gt; E
gt; F
gt;
gt;
gt;
gt; New A
gt; New A
gt; New B
gt; Term B
gt; Term E
gt; New F
gt; Term D
gt; Term C
gt; Term C
gt; New F
gt; New B
gt; Term A
gt;
gt; {=IF($C$13:$C$24=quot;newquot;,COUNTIF($D$13:$D$24,quot;Aquot;))}
gt;
gt; Thank you for taking time to solve the formula.
gt;
gt; Dinesh
gt;
gt;
gt;
gt;
thanks. it works.quot;Dineshquot; wrote:

gt; Hi,
gt;
gt; When I enter the formula which is at the end, I get the result of 3 in Col
gt; B, row 2 instead of 2.
gt;
gt;
gt; CategoryNewTerm
gt; A2
gt; B
gt; C
gt; D
gt; E
gt; F
gt;
gt;
gt;
gt; NewA
gt; NewA
gt; NewB
gt; TermB
gt; TermE
gt; NewF
gt; TermD
gt; TermC
gt; TermC
gt; NewF
gt; NewB
gt; TermA
gt;
gt; {=IF($C$13:$C$24=quot;newquot;,COUNTIF($D$13:$D$24,quot;Aquot;))}
gt;
gt; Thank you for taking time to solve the formula.
gt;
gt; Dinesh
gt;
gt;
gt;
gt;

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=quot;newquot;),--($D$13:$D$24=quot;Aquot;))
It didn't work.

Thanks in advance.quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Try this:
gt;
gt; =SUMPRODUCT(--($C$13:$C$24=quot;newquot;),--($D$13:$D$24=quot;Aquot;))
gt;
gt; Biff
gt;
gt; quot;Dineshquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; When I enter the formula which is at the end, I get the result of 3 in Col
gt; gt; B, row 2 instead of 2.
gt; gt;
gt; gt;
gt; gt; Category New Term
gt; gt; A 2
gt; gt; B
gt; gt; C
gt; gt; D
gt; gt; E
gt; gt; F
gt; gt;
gt; gt;
gt; gt;
gt; gt; New A
gt; gt; New A
gt; gt; New B
gt; gt; Term B
gt; gt; Term E
gt; gt; New F
gt; gt; Term D
gt; gt; Term C
gt; gt; Term C
gt; gt; New F
gt; gt; New B
gt; gt; Term A
gt; gt;
gt; gt; {=IF($C$13:$C$24=quot;newquot;,COUNTIF($D$13:$D$24,quot;Aquot;))}
gt; gt;
gt; gt; Thank you for taking time to solve the formula.
gt; gt;
gt; gt; Dinesh
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

Try this:

=SUMPRODUCT(--($C$13:$C$24=quot;newquot;),--($D$13:$D$24=quot;Aquot;),$E$13:$E$24)

Biff

quot;Dineshquot; gt; wrote in message
...
gt; What if I want to add the values which is on Col E,rows 13 to 24. I tried
gt; putting
gt; =sum(e13:e24),if(sumproduct(--($C$13:$C$24=quot;newquot;),--($D$13:$D$24=quot;Aquot;))
gt; It didn't work.
gt;
gt; Thanks in advance.
gt;
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; =SUMPRODUCT(--($C$13:$C$24=quot;newquot;),--($D$13:$D$24=quot;Aquot;))
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Dineshquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; When I enter the formula which is at the end, I get the result of 3 in
gt;gt; gt; Col
gt;gt; gt; B, row 2 instead of 2.
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; Category New Term
gt;gt; gt; A 2
gt;gt; gt; B
gt;gt; gt; C
gt;gt; gt; D
gt;gt; gt; E
gt;gt; gt; F
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; New A
gt;gt; gt; New A
gt;gt; gt; New B
gt;gt; gt; Term B
gt;gt; gt; Term E
gt;gt; gt; New F
gt;gt; gt; Term D
gt;gt; gt; Term C
gt;gt; gt; Term C
gt;gt; gt; New F
gt;gt; gt; New B
gt;gt; gt; Term A
gt;gt; gt;
gt;gt; gt; {=IF($C$13:$C$24=quot;newquot;,COUNTIF($D$13:$D$24,quot;Aquot;))}
gt;gt; gt;
gt;gt; gt; Thank you for taking time to solve the formula.
gt;gt; gt;
gt;gt; gt; Dinesh
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
Thanks Biff.

quot;Biffquot; wrote:

gt; Try this:
gt;
gt; =SUMPRODUCT(--($C$13:$C$24=quot;newquot;),--($D$13:$D$24=quot;Aquot;),$E$13:$E$24)
gt;
gt; Biff
gt;
gt; quot;Dineshquot; gt; wrote in message
gt; ...
gt; gt; What if I want to add the values which is on Col E,rows 13 to 24. I tried
gt; gt; putting
gt; gt; =sum(e13:e24),if(sumproduct(--($C$13:$C$24=quot;newquot;),--($D$13:$D$24=quot;Aquot;))
gt; gt; It didn't work.
gt; gt;
gt; gt; Thanks in advance.
gt; gt;
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Hi!
gt; gt;gt;
gt; gt;gt; Try this:
gt; gt;gt;
gt; gt;gt; =SUMPRODUCT(--($C$13:$C$24=quot;newquot;),--($D$13:$D$24=quot;Aquot;))
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;Dineshquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi,
gt; gt;gt; gt;
gt; gt;gt; gt; When I enter the formula which is at the end, I get the result of 3 in
gt; gt;gt; gt; Col
gt; gt;gt; gt; B, row 2 instead of 2.
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; Category New Term
gt; gt;gt; gt; A 2
gt; gt;gt; gt; B
gt; gt;gt; gt; C
gt; gt;gt; gt; D
gt; gt;gt; gt; E
gt; gt;gt; gt; F
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; New A
gt; gt;gt; gt; New A
gt; gt;gt; gt; New B
gt; gt;gt; gt; Term B
gt; gt;gt; gt; Term E
gt; gt;gt; gt; New F
gt; gt;gt; gt; Term D
gt; gt;gt; gt; Term C
gt; gt;gt; gt; Term C
gt; gt;gt; gt; New F
gt; gt;gt; gt; New B
gt; gt;gt; gt; Term A
gt; gt;gt; gt;
gt; gt;gt; gt; {=IF($C$13:$C$24=quot;newquot;,COUNTIF($D$13:$D$24,quot;Aquot;))}
gt; gt;gt; gt;
gt; gt;gt; gt; Thank you for taking time to solve the formula.
gt; gt;gt; gt;
gt; gt;gt; gt; Dinesh
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

You're welcome!

Biff

quot;Dineshquot; gt; wrote in message
...
gt; Thanks Biff.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Try this:
gt;gt;
gt;gt; =SUMPRODUCT(--($C$13:$C$24=quot;newquot;),--($D$13:$D$24=quot;Aquot;),$E$13:$E$24)
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Dineshquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; What if I want to add the values which is on Col E,rows 13 to 24. I
gt;gt; gt; tried
gt;gt; gt; putting
gt;gt; gt; =sum(e13:e24),if(sumproduct(--($C$13:$C$24=quot;newquot;),--($D$13:$D$24=quot;Aquot;))
gt;gt; gt; It didn't work.
gt;gt; gt;
gt;gt; gt; Thanks in advance.
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi!
gt;gt; gt;gt;
gt;gt; gt;gt; Try this:
gt;gt; gt;gt;
gt;gt; gt;gt; =SUMPRODUCT(--($C$13:$C$24=quot;newquot;),--($D$13:$D$24=quot;Aquot;))
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Dineshquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Hi,
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; When I enter the formula which is at the end, I get the result of 3
gt;gt; gt;gt; gt; in
gt;gt; gt;gt; gt; Col
gt;gt; gt;gt; gt; B, row 2 instead of 2.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Category New Term
gt;gt; gt;gt; gt; A 2
gt;gt; gt;gt; gt; B
gt;gt; gt;gt; gt; C
gt;gt; gt;gt; gt; D
gt;gt; gt;gt; gt; E
gt;gt; gt;gt; gt; F
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; New A
gt;gt; gt;gt; gt; New A
gt;gt; gt;gt; gt; New B
gt;gt; gt;gt; gt; Term B
gt;gt; gt;gt; gt; Term E
gt;gt; gt;gt; gt; New F
gt;gt; gt;gt; gt; Term D
gt;gt; gt;gt; gt; Term C
gt;gt; gt;gt; gt; Term C
gt;gt; gt;gt; gt; New F
gt;gt; gt;gt; gt; New B
gt;gt; gt;gt; gt; Term A
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; {=IF($C$13:$C$24=quot;newquot;,COUNTIF($D$13:$D$24,quot;Aquot;))}
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Thank you for taking time to solve the formula.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Dinesh
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;