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" <Dinesh@discussions.microsoft.com> wrote in message
news:2AAEC802-7648-4618-BDAD-5B5DE567FAB8@microsoft.com...
> 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" <Dinesh@discussions.microsoft.com> wrote in message
>> news:37435684-7F1D-4E48-9F0A-C71050D7E6B2@microsoft.com...
>> > 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
>> >
>> >
>> >
>> >
>>
>>
>>

Thanks Biff.

"Biff" wrote:

> Try this:
>
> =SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A"),$E$13:$E$24)
>
> Biff
>
> "Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
> news:2AAEC802-7648-4618-BDAD-5B5DE567FAB8@microsoft.com...
> > 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" <Dinesh@discussions.microsoft.com> wrote in message
> >> news:37435684-7F1D-4E48-9F0A-C71050D7E6B2@microsoft.com...
> >> > 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
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>
>

You're welcome!

Biff

"Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
news:56CB9931-4658-4804-BE44-05782264DFDC@microsoft.com...
> Thanks Biff.
>
> "Biff" wrote:
>
>> Try this:
>>
>> =SUMPRODUCT(--($C$13:$C$24="new"),--($D$13:$D$24="A"),$E$13:$E$24)
>>
>> Biff
>>
>> "Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
>> news:2AAEC802-7648-4618-BDAD-5B5DE567FAB8@microsoft.com...
>> > 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" <Dinesh@discussions.microsoft.com> wrote in message
>> >> news:37435684-7F1D-4E48-9F0A-C71050D7E6B2@microsoft.com...
>> >> > 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
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>