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
|