Why is this giving me an error? It doesn't make sense!!!!
SUMPRODUCT(--('Raw - 2nd'!$C$2:$C$65536=$A37),--(MONTH('Raw -
2nd'!$b$2:$b$65536=4),'Raw - 2nd'!$J$2:$J$65536)
Column c is employee number
Column b is date range
Column j is $$ range
"Bob Phillips" wrote:
> =SUMPRODUCT(--(APR_05!$C$2:$C$1000=$A37),--(MONTH(APR_05!$D$2:$D$1000=7),APR
> _05!$J$2:$J$1000)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Curtis" <[email protected]> wrote in message
> news:[email protected]...
> > SO far I have =SUMIF(APR_05!$C$2:$C$65536,$A37,APR_05!$J$2:$J$65536)
> >
> > this sums up the $$ by employee number. I need to add a formula that pulls
> > the $$ by the month as well .
> >
> > "Matt Lunn" wrote:
> >
> > > Curtis,
> > >
> > > An array formula would work here. Could you please give a little bit
> more
> > > detail about your data? You mention days. Does this mean the month is
> to be
> > > calculated from a date?
> > >
> > > Thanks,
> > > Matt
> > >
> > > "Curtis" wrote:
> > >
> > > > I need to calculate the sum of number dependate on 2 conditions. One
> > > > condition is emplyee number ( in a column of many numbers) and the
> other is
> > > > the month (in a column listed with many days)
>
>
>
Bookmarks