Formulas in excel

M

Michelle

I have two spreadsheets I want to link. The information on the first spreadsheet date and amount will change every month. On the second spreadsheet I have the twelve months listed and want to pull the monthly amount from the first spreadsheet to poplulate the months. Please help
 
B

Bernard Liengme

HI Michelle,
You can use formulas such as =Sheet1!A1. These are readily made by
'pointing' to the cell. Or have I missed the mark?

Bernard

Michelle said:
I have two spreadsheets I want to link. The information on the first
Click to expand...
spreadsheet date and amount will change every month. On the second
spreadsheet I have the twelve months listed and want to pull the monthly
amount from the first spreadsheet to poplulate the months. Please help
 
P

Paul B

Michelle, dates in sheet1 column A, amount in column B this will look for
the month may in column A and add the amounts in column B, is this what you
want? change 5 to the month you want
=SUMPRODUCT((MONTH(Sheet1!A1:A100)=5)*(Sheet1!B1:B100))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
Michelle said:
I have two spreadsheets I want to link. The information on the first
Click to expand...
spreadsheet date and amount will change every month. On the second
spreadsheet I have the twelve months listed and want to pull the monthly
amount from the first spreadsheet to poplulate the months. Please help
 
M

Michelle

Hi,

This is the formula I'm trying to use but it's not working.
=SUMPRODUCT(MONTH('[Sheet1]Tax ProvisIon Analysis'!A4)=1)=('[Sheet1]Tax ProvisIon Analysis'!D16)
The information is on sheet1 but I want to setup sheet2 to record the amount in the correct month. The information in sheet1 will change every month. If you know a different formula that will work please let me know.

For example,
Sheet 1 Sheet 2
(A4) January (A7) January (B7) $500
(D16) $500 (A8) February (B8) $100
(A4) February
$100
Thanks
 
M

Michelle

Hi,

Here's a better example of what I'm trying to accomplish.
The information is on sheet1 but I want to setup sheet2 to record the amount in the correct month. The information in sheet1 will change every month. If you know a different formula that will work please let me know.

For example,
Sheet 1 Sheet 2
(A4) January (A7) January (B7) $500
(D16) $500 (A8) February (B8) $100
(A4) February
$100
Thanks
 
Top