Prev: =vlookup(A1:A835,"bbb",AI7:AL165,C7:C165) giving #value! ????????
Next: count if for blanks with 'or'
From: djhunt77 on 28 Mar 2010 19:36
Thanks Bob - that suggestion worked perfectly!

"Bob Phillips" wrote:

> You just can't, it's daft isn't it, makes SUMIFS more or less pointless IMO.
>
> Try this
>
> =SUMPRODUCT(--(Category=A2),--(Month(DateOfService)=1),Amount)
>
> --
>
> HTH
>
> Bob
>
> "djhunt77" <djhunt77(a)discussions.microsoft.com> wrote in message
> news:DE76C209-BCB7-4738-9B76-37ED4FD3C468(a)microsoft.com...
> >I have a Detail worksheet with three named ranges: Category, DateOfService
> > and Amount.
> >
> > I have a Summary worksheet where I am trying to summaries the amounts by
> > Category (represented by the rows) and Month (represented by the columns).
> >
> > Why do I get an error when I try to use this formula on the Summary sheet?
> >
> > =SUMIFS(Amount,Category,A2,Month(DateOfService),1)
> >
> > where A2 is the first row in the summary data.
>
>
> .
>
 | 
Pages: 1
Prev: =vlookup(A1:A835,"bbb",AI7:AL165,C7:C165) giving #value! ????????
Next: count if for blanks with 'or'