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