=SUMIF(book2!L3:AF3, "=book1!O30", book2!L20:AF20)

[dond]

Can someone assist. Although the formula is not rejected it doesn't do anything. In the formula below l3:af3 refer to a range of consecutive dates. o30 to a date about midway in the range between l3 and af3, and l20:af50 to a range of general numbers. What am I doing wrong??????????
As you can see I am working across two worksheets.

=SUMIF(book2!L3:AF3, "=book1!O30", book2!L20:AF20)

[Bob Phillips]

Try

=SUMIF(book2!L3:AF3, book1!O30, book2!L20:AF20

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dond" <[email protected]> wrote in message
news:[email protected]...
>
> Can someone assist. Although the formula is not rejected it doesn't do
> anything. In the formula below l3:af3 refer to a range of consecutive
> dates. o30 to a date about midway in the range between l3 and af3, and
> l20:af50 to a range of general numbers. What am I doing
> wrong??????????
> As you can see I am working across two worksheets.
>
> =SUMIF(book2!L3:AF3, "=book1!O30", book2!L20:AF20)
>
>
> --
> dond
> ------------------------------------------------------------------------
> dond's Profile:
http://www.excelforum.com/member.php...o&userid=25477
> View this thread: http://www.excelforum.com/showthread...hreadid=483090
>