| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if argument?
I am compiling a capital purchase forecast over five years togther with
forecast depreciation. The top of my spread sheet has months 1 through to 60. I would like to calculate purchases in year 1, namely if it occurred between months 1 and 12, similarly calculate purchases in year 2 ( occurring between month 13 and 24) etc. Column A2:A20 has a list of proposed assets, column B2:B20 their purchase cost and column C2:C20 the proposed month of expenditure (1-60). Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if argument?
=sumproduct(--($C$2:$C$20=1),--($C$2:$C$20<=12),$b$2:$B$20)
etc. -- HTH RP (remove nothere from the email address if mailing direct) "Struggling of Essex" wrote in message ... I am compiling a capital purchase forecast over five years togther with forecast depreciation. The top of my spread sheet has months 1 through to 60. I would like to calculate purchases in year 1, namely if it occurred between months 1 and 12, similarly calculate purchases in year 2 ( occurring between month 13 and 24) etc. Column A2:A20 has a list of proposed assets, column B2:B20 their purchase cost and column C2:C20 the proposed month of expenditure (1-60). Can anyone help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if argument?
Bob,
Thanks for that, can you help me though, what does "- -" signify thanks "Bob Phillips" wrote: =sumproduct(--($C$2:$C$20=1),--($C$2:$C$20<=12),$b$2:$B$20) etc. -- HTH RP (remove nothere from the email address if mailing direct) "Struggling of Essex" wrote in message ... I am compiling a capital purchase forecast over five years togther with forecast depreciation. The top of my spread sheet has months 1 through to 60. I would like to calculate purchases in year 1, namely if it occurred between months 1 and 12, similarly calculate purchases in year 2 ( occurring between month 13 and 24) etc. Column A2:A20 has a list of proposed assets, column B2:B20 their purchase cost and column C2:C20 the proposed month of expenditure (1-60). Can anyone help? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if argument?
It is all explained at http://www.xldynamic.com/source/xld.SUMPRODUCT.html
-- HTH RP (remove nothere from the email address if mailing direct) "Struggling of Essex" wrote in message ... Bob, Thanks for that, can you help me though, what does "- -" signify thanks "Bob Phillips" wrote: =sumproduct(--($C$2:$C$20=1),--($C$2:$C$20<=12),$b$2:$B$20) etc. -- HTH RP (remove nothere from the email address if mailing direct) "Struggling of Essex" wrote in message ... I am compiling a capital purchase forecast over five years togther with forecast depreciation. The top of my spread sheet has months 1 through to 60. I would like to calculate purchases in year 1, namely if it occurred between months 1 and 12, similarly calculate purchases in year 2 ( occurring between month 13 and 24) etc. Column A2:A20 has a list of proposed assets, column B2:B20 their purchase cost and column C2:C20 the proposed month of expenditure (1-60). Can anyone help? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if argument?
Bob,
Many thanks for your time. "Bob Phillips" wrote: It is all explained at http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH RP (remove nothere from the email address if mailing direct) "Struggling of Essex" wrote in message ... Bob, Thanks for that, can you help me though, what does "- -" signify thanks "Bob Phillips" wrote: =sumproduct(--($C$2:$C$20=1),--($C$2:$C$20<=12),$b$2:$B$20) etc. -- HTH RP (remove nothere from the email address if mailing direct) "Struggling of Essex" wrote in message ... I am compiling a capital purchase forecast over five years togther with forecast depreciation. The top of my spread sheet has months 1 through to 60. I would like to calculate purchases in year 1, namely if it occurred between months 1 and 12, similarly calculate purchases in year 2 ( occurring between month 13 and 24) etc. Column A2:A20 has a list of proposed assets, column B2:B20 their purchase cost and column C2:C20 the proposed month of expenditure (1-60). Can anyone help? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if argument?
I found it
"double unary operator"? "Bob Phillips" wrote: It is all explained at http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH RP (remove nothere from the email address if mailing direct) "Struggling of Essex" wrote in message ... Bob, Thanks for that, can you help me though, what does "- -" signify thanks "Bob Phillips" wrote: =sumproduct(--($C$2:$C$20=1),--($C$2:$C$20<=12),$b$2:$B$20) etc. -- HTH RP (remove nothere from the email address if mailing direct) "Struggling of Essex" wrote in message ... I am compiling a capital purchase forecast over five years togther with forecast depreciation. The top of my spread sheet has months 1 through to 60. I would like to calculate purchases in year 1, namely if it occurred between months 1 and 12, similarly calculate purchases in year 2 ( occurring between month 13 and 24) etc. Column A2:A20 has a list of proposed assets, column B2:B20 their purchase cost and column C2:C20 the proposed month of expenditure (1-60). Can anyone help? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if argument?
Yes.
-- HTH RP (remove nothere from the email address if mailing direct) "Struggling of Essex" wrote in message ... I found it "double unary operator"? "Bob Phillips" wrote: It is all explained at http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH RP (remove nothere from the email address if mailing direct) "Struggling of Essex" wrote in message ... Bob, Thanks for that, can you help me though, what does "- -" signify thanks "Bob Phillips" wrote: =sumproduct(--($C$2:$C$20=1),--($C$2:$C$20<=12),$b$2:$B$20) etc. -- HTH RP (remove nothere from the email address if mailing direct) "Struggling of Essex" wrote in message ... I am compiling a capital purchase forecast over five years togther with forecast depreciation. The top of my spread sheet has months 1 through to 60. I would like to calculate purchases in year 1, namely if it occurred between months 1 and 12, similarly calculate purchases in year 2 ( occurring between month 13 and 24) etc. Column A2:A20 has a list of proposed assets, column B2:B20 their purchase cost and column C2:C20 the proposed month of expenditure (1-60). Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| countif greater/less than argument | Excel Worksheet Functions | |||
| How do I set up an argument which asks for multiple criteria | Excel Discussion (Misc queries) | |||
| text argument in vlook up which has a "" | Excel Worksheet Functions | |||
| read in Vlookup an argument that has quotations(") | Excel Discussion (Misc queries) | |||
Linear Mode
