Home |
Search |
Today's Posts |
#1
|
|||
|
|||
=SUMIF(book2!L3:AF3, "=book1!O30", book2!L20:AF20)
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 |
#2
|
|||
|
|||
=SUMIF(book2!L3:AF3, "=book1!O30", book2!L20:AF20)
Try
=SUMIF(book2!L3:AF3, book1!O30, book2!L20:AF20 -- HTH RP (remove nothere from the email address if mailing direct) "dond" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|