I am sure a similar thing has been posted but I do not always know how to word what I am trying to find.
This is the formula I am trying to figure out. I would like one that would reference several pages and cells at the same time. For instance, I have a formula that searches c9:c48 for the word "Received". If it finds it then it it adds another cell to the cell with the inventory, if not it subtracts from above.
=IF(C9:C48="Received",D9:D48+J11, J11-D12)
What I cant figure out how to do is do a formula that is similar on a separate page but basically it will need to add the 2 together. IE, take the number of the cell IF the text = Inventory AND the date equals the end of the month (as in 01/31/11 or 12/31/11) in the cells C9:C48 and B9:B48 on sheet1 and add to sheet2 with the same reference, giving a total on sheet3. So if c9:c48 = Inventory, and b9:48 equals 01/31/11, then the cell that is with those two on the same row j9:j48 should be added on both sheets then give the total on sheet3. I am not sure this is even possible but I wanted to ask.
This is the formula I am trying to figure out. I would like one that would reference several pages and cells at the same time. For instance, I have a formula that searches c9:c48 for the word "Received". If it finds it then it it adds another cell to the cell with the inventory, if not it subtracts from above.
=IF(C9:C48="Received",D9:D48+J11, J11-D12)
What I cant figure out how to do is do a formula that is similar on a separate page but basically it will need to add the 2 together. IE, take the number of the cell IF the text = Inventory AND the date equals the end of the month (as in 01/31/11 or 12/31/11) in the cells C9:C48 and B9:B48 on sheet1 and add to sheet2 with the same reference, giving a total on sheet3. So if c9:c48 = Inventory, and b9:48 equals 01/31/11, then the cell that is with those two on the same row j9:j48 should be added on both sheets then give the total on sheet3. I am not sure this is even possible but I wanted to ask.
