How do I use the criteria "is not blank" in a SUMIF formula?

[Pretender]

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 "IS NOT
BLANK"? 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.

 

[Ron Coderre]

Try something like this:

For a list of values (or blanks) in A1:A10 and numbers in B1:B10

B11: =SUMIF(A1:A10,"<>",B1:B10)

Note: if a cell contains "", an apostrophe, or a space, it may appear blank
but it is NOT.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Pretender]

That's it! Thanks much.

Try something like this:

For a list of values (or blanks) in A1:A10 and numbers in B1:B10

B11: =SUMIF(A1:A10,"<>",B1:B10)

Note: if a cell contains "", an apostrophe, or a space, it may appear blank
but it is NOT.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro