Multiple sheet references in one function

A

Alex

=SUM(--('Sheet1'!$B$2:$B$2000<=BB$3),--('Sheet1'!$B$2:$B$2000>=BB$2),--('Sheet1'!$D$2:$D$2000=$B7),
--('Sheet2'!$B$2:$B$2000<=BB$3),--('Sheet2'!$B$2:$B$2000>=BB$2),--('Sheet2'!$D$2:$D$2000=$B7),
--('Sheet3'!$B$2:$B$2000<=BB$3),--('Sheet3'!$B$2:$B$2000>=BB$2),--('Sheet3'!$D$2:$D$2000=$B7),
--('Sheet4'!$B$2:$B$2000<=BB$3),--('Sheet4'!$B$2:$B$2000>=BB$2),--('Sheet4'!$D$2:$D$2000=$B7))

Sheets 1-4 all list claims but they need to be seperated. The values that
are targeted in column B are the dates, and the function is intended to tally
the cumulative number of claims from the four sheets from the date specified
in BB2 to the date specified in BB3 (usually one month, like 3/1/01-3/31/10).
The formula works when I omit the reference for any two sheets, but not when
I attempt to reference four in one formula.

Thanks.
 

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

Need help in creating horizontal array using either macro or someformula 1
IF statement with multiple VLOOKUPs 0
multiple sheet looks up and match 4
How to check a condition and write another cell 0
Row references 1
Moving data based on specific field 4
Array with many cells from a row but not in order or together 11
Hate DBL post but I really need help 0

Top