lewis_blackburn
New Member
- Joined
- Jul 31, 2008
- Messages
- 11
<HTML>
<P>Here is my scenario. I have a two-column sheet of investment transactions (fund and shares). I want to sum the shares for funds of a certain "category". I define what funds are in a category by listing them in a named range. For example, my sample spreadsheet looks like this:</P>
<TABLE><TBODY><TR><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR><TD>1</TD><TD>VTSMX</TD><TD>VBMFX</TD><TD>6</TD></TR><TR><TD>2</TD><TD>VTSAX</TD><TD>VIPSX</TD><TD>3</TD></TR><TR><TD>3</TD><TD>PTSMX</TD><TD>VTSMX</TD><TD>8</TD></TR><TR><TD>4</TD><TD></TD><TD>PTSMX</TD><TD>2</TD></TR><TR><TD>5</TD><TD></TD><TD>VGTSX</TD><TD>6</TD></TR></TBODY></TABLE>
<p>Cells A1:A3 are a named range called "UsStock". So what I want to do is something like this (with the condition being the part I can't figure out):
=SUMIF(B1:B5, [is in the named range called UsStock], C1:C5)
Can anyone help me complete this formula?
Thanks!</p>
</HTML>
<P>Here is my scenario. I have a two-column sheet of investment transactions (fund and shares). I want to sum the shares for funds of a certain "category". I define what funds are in a category by listing them in a named range. For example, my sample spreadsheet looks like this:</P>
<TABLE><TBODY><TR><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR><TD>1</TD><TD>VTSMX</TD><TD>VBMFX</TD><TD>6</TD></TR><TR><TD>2</TD><TD>VTSAX</TD><TD>VIPSX</TD><TD>3</TD></TR><TR><TD>3</TD><TD>PTSMX</TD><TD>VTSMX</TD><TD>8</TD></TR><TR><TD>4</TD><TD></TD><TD>PTSMX</TD><TD>2</TD></TR><TR><TD>5</TD><TD></TD><TD>VGTSX</TD><TD>6</TD></TR></TBODY></TABLE>
<p>Cells A1:A3 are a named range called "UsStock". So what I want to do is something like this (with the condition being the part I can't figure out):
=SUMIF(B1:B5, [is in the named range called UsStock], C1:C5)
Can anyone help me complete this formula?
Thanks!</p>
</HTML>
