D
Dave
Hi, i have been trying to solve a problem for ages and i really need
help!!
ive got two spreadsheets:
first one is an income spreadhseet that shows when money is ndue, how
much and who from, format as below:
Company Name Due Date Amount
SSSSS 01/07/2004 £50
The second spreadsheet is a cashflow sheet that will have income and
expenditure on a monthly basis. format below:
Company name Apr May Jun July Aug etc
ssssss x
what i want is query that will link the two together so that i can
write a query in the cell marked x to search the income spreadsheet
for any amount of money coming from any given company, then check what
dates the money is due and if the due date is between 01/04/2004 and
30/04/2004 then return the amount of monye due in the cell marked x
otherwise return 0. ive tried using nested ifs but i cant quite solve
the problem. i was trying to set it up so that it searched the column
company name in income spreadhseet and if it match the company name on
the cashflow spreadsheet then it would seach for if money was due in a
certain month, then return the money in the amount cell or 0..... not
sure if ive explained it ok but its driving me mad and its been a long
week!!! any suggestions greatfly appreciated
cheers
Dave
help!!
ive got two spreadsheets:
first one is an income spreadhseet that shows when money is ndue, how
much and who from, format as below:
Company Name Due Date Amount
SSSSS 01/07/2004 £50
The second spreadsheet is a cashflow sheet that will have income and
expenditure on a monthly basis. format below:
Company name Apr May Jun July Aug etc
ssssss x
what i want is query that will link the two together so that i can
write a query in the cell marked x to search the income spreadsheet
for any amount of money coming from any given company, then check what
dates the money is due and if the due date is between 01/04/2004 and
30/04/2004 then return the amount of monye due in the cell marked x
otherwise return 0. ive tried using nested ifs but i cant quite solve
the problem. i was trying to set it up so that it searched the column
company name in income spreadhseet and if it match the company name on
the cashflow spreadsheet then it would seach for if money was due in a
certain month, then return the money in the amount cell or 0..... not
sure if ive explained it ok but its driving me mad and its been a long
week!!! any suggestions greatfly appreciated
cheers
Dave