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?

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?

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?

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?

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?

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?

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?