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

  • Thread starter Thread starter dond
  • Start date Start date
D

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)
 
Try

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

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=SUMIF(Rewards!$AH$3:$BI$3, ">Targets!O30:<O31", Rewards!$AH$20:$BI$20) 13
Excel 2007 Problem with SUMIF 2
Comparing two books and two sheets, Problems with color coding correct sheet 1
Use of Month() within SumIF() 1
Using Index, Match and Search to populate items to a calendar view 2
SUMIF nesting ??? 3
Sumif across Multiple sheets 2
Counting number of times name occurs between two dates 2

Back
Top