Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help again on an if nested formula | Excel Discussion (Misc queries) | |||
Nested Formula - HELP | Excel Worksheet Functions | |||
Nested Formula? | Excel Worksheet Functions | |||
nested formula | Excel Worksheet Functions | |||
Nested Formula | Excel Worksheet Functions |