software

I have a simple three column spreadsheet: Column 1 is a description; Column 2
is a range of extensions (6700-6749; 6800-6815; etc.); Column 3 is the number
of extensions from column 2, which I manually typed. At the botton of Column
3 I want to sum all of the numbers in Column 3 for which the corresponding
cell in Column 2 is not blank. I am creating a dial plan and know that I do
not have enough extensions, so some of the cells in Column 2 are blank
(meaning I do not yet have those extensions acquired).

Is there a criteria I can use in the SUMIF function that means quot;IS NOT
BLANKquot;? I want this formula to sum only the numbers in Column 3 for which I
have typed the range of extensions in Column 2. Thanks in advance for any
help.

That's it! Thanks much.

quot;Ron Coderrequot; wrote:

gt; Try something like this:
gt;
gt; For a list of values (or blanks) in A1:A10 and numbers in B1:B10
gt;
gt; B11: =SUMIF(A1:A10,quot;lt;gt;quot;,B1:B10)
gt;
gt; Note: if a cell contains quot;quot;, an apostrophe, or a space, it may appear blank
gt; but it is NOT.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Pretenderquot; wrote:
gt;
gt; gt; I have a simple three column spreadsheet: Column 1 is a description; Column 2
gt; gt; is a range of extensions (6700-6749; 6800-6815; etc.); Column 3 is the number
gt; gt; of extensions from column 2, which I manually typed. At the botton of Column
gt; gt; 3 I want to sum all of the numbers in Column 3 for which the corresponding
gt; gt; cell in Column 2 is not blank. I am creating a dial plan and know that I do
gt; gt; not have enough extensions, so some of the cells in Column 2 are blank
gt; gt; (meaning I do not yet have those extensions acquired).
gt; gt;
gt; gt; Is there a criteria I can use in the SUMIF function that means quot;IS NOT
gt; gt; BLANKquot;? I want this formula to sum only the numbers in Column 3 for which I
gt; gt; have typed the range of extensions in Column 2. Thanks in advance for any
gt; gt; help.