please help how to combine IF function with Countif function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dinesh - 30 Mar 2006 02:33 GMT

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 to this Message

Biff - 30 Mar 2006 02:50 GMT

Hi!

Try this:

=SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A"))

Biff

> Hi,
>
[quoted text clipped - 27 lines]
>
> Dinesh

Reply to this Message

Dinesh - 30 Mar 2006 07:37 GMT

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.

> Hi!
>
[quoted text clipped - 35 lines]
> >
> > Dinesh

Reply to this Message

Biff - 30 Mar 2006 08:15 GMT

Try this:

=SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A"),$E$13:$E$24)

Biff

> What if I want to add the values which is on Col E,rows 13 to 24. I tried
> putting
[quoted text clipped - 43 lines]
>> >
>> > Dinesh

Reply to this Message

Dinesh - 30 Mar 2006 17:56 GMT

Thanks Biff.

> Try this:
>
[quoted text clipped - 49 lines]
> >> >
> >> > Dinesh

Reply to this Message

Biff - 30 Mar 2006 20:28 GMT

You're welcome!

Biff

> Thanks Biff.
>
[quoted text clipped - 53 lines]
>> >> >
>> >> > Dinesh

Reply to this Message

Dinesh - 30 Mar 2006 03:39 GMT

thanks. it works.

> Hi,
>
[quoted text clipped - 27 lines]
>
> Dinesh

Reply to this Message