Help

[Monty]

In column (I) I have cost centres, which range from 2001 to 2042 and in
column (H) I have the number of days taken for payment. In cell AA4 and I
want to return all payments over 5 days belonging to cost centres
2033,2036,2037 & 2041.

Can you please help.

Monty

[Dav]

In column (I) I have cost centres, which range from 2001 to 2042 and in
column (H) I have the number of days taken for payment. In cell AA4 and I
want to return all payments over 5 days belonging to cost centres
2033,2036,2037 & 2041.

Can you please help.

Monty

=SUMPRODUCT((h1:h100>0)*(i1:i100={2033, 2036, 2037, 2041}))

Regards

Dav

[Monty]

Cheers

"Dav" wrote:

>
> Monty Wrote:
> > In column (I) I have cost centres, which range from 2001 to 2042 and in
> > column (H) I have the number of days taken for payment. In cell AA4 and
> > I
> > want to return all payments over 5 days belonging to cost centres
> > 2033,2036,2037 & 2041.
> >
> > Can you please help.
> >
> > Monty
>
>
> =SUMPRODUCT((h1:h100>0)*(i1:i100={2033, 2036, 2037, 2041}))
>
> Regards
>
> Dav
>
>
> --
> Dav
> ------------------------------------------------------------------------
> Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
> View this thread: http://www.excelforum.com/showthread...hreadid=564628
>
>