Nested formula help
 

I am working with Excel 2003
In column J on sheet OWN_AR I have information as to status in the form of
letters ie. "V".

In column i on sheet OWN_AR I have numbers ie. 1, 2, or 3.

What I want the formula to do is
Add up the number in column I only if column J is showing a "V"
I have tried =COUNTIF(OWN_AR!J2:J689,"V") but can't figure out how to get it
to choose the figure in column i not just count column j.

Nested formula help
 

Try this:

=Sumif(OWN_AR!J2:J689,"V",OWN_AR!I2:I689)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rescueme" wrote in message
...
I am working with Excel 2003
In column J on sheet OWN_AR I have information as to status in the form of
letters ie. "V".

In column i on sheet OWN_AR I have numbers ie. 1, 2, or 3.

What I want the formula to do is
Add up the number in column I only if column J is showing a "V"
I have tried =COUNTIF(OWN_AR!J2:J689,"V") but can't figure out how to get
it
to choose the figure in column i not just count column j.

Nested formula help
 

Another option:
=SUMPRODUCT((OWN_AR!J2:J689="V")*OWN_AR!I2:I689)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rescueme" wrote:
I am working with Excel 2003
In column J on sheet OWN_AR I have information as to status in the form of
letters ie. "V".

In column i on sheet OWN_AR I have numbers ie. 1, 2, or 3.

What I want the formula to do is
Add up the number in column I only if column J is showing a "V"
I have tried =COUNTIF(OWN_AR!J2:J689,"V") but can't figure out how to get it
to choose the figure in column i not just count column j.

Nested formula help
 

Thanks, That worked - I had been trying the Sumif function but kept getting
things in the wrong order.

"RagDyer" wrote:

Try this:

=Sumif(OWN_AR!J2:J689,"V",OWN_AR!I2:I689)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rescueme" wrote in message
...
I am working with Excel 2003
In column J on sheet OWN_AR I have information as to status in the form of
letters ie. "V".

In column i on sheet OWN_AR I have numbers ie. 1, 2, or 3.

What I want the formula to do is
Add up the number in column I only if column J is showing a "V"
I have tried =COUNTIF(OWN_AR!J2:J689,"V") but can't figure out how to get
it
to choose the figure in column i not just count column j.

Nested formula help
 

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rescueme" wrote in message
...
Thanks, That worked - I had been trying the Sumif function but kept
getting
things in the wrong order.

"RagDyer" wrote:

Try this:

=Sumif(OWN_AR!J2:J689,"V",OWN_AR!I2:I689)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rescueme" wrote in message
...
I am working with Excel 2003
In column J on sheet OWN_AR I have information as to status in the form
of
letters ie. "V".

In column i on sheet OWN_AR I have numbers ie. 1, 2, or 3.

What I want the formula to do is
Add up the number in column I only if column J is showing a "V"
I have tried =COUNTIF(OWN_AR!J2:J689,"V") but can't figure out how to
get
it
to choose the figure in column i not just count column j.