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
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>