Sumif for a nonblank cell

Hi all,

I would like to set a formula in a cell to sum up the value of all nonblank
cells.

The detail is that I got a data file download from a system, column C
contains local value and column D contains the USD value, not all the USD
cells have value because if the bill is originally billed at local currency,
the USD value is empty, but if the bill is billed at USD, it automatically
generate a local value in column C. I need the know the total of original
value of both USD and local.

Column C Column D
1000 100
200 20
350
410 41
288
2350

To get the total value of Col D is easy, simply set sum(D2:D7) at D8.
To get the total value of Col C, I set sumif(D2:D7, <>"", C2:C6), but it did
not work.

Anyone can help ?

et

The following formula should work, if the cells are really blank:

=SUMIF(D2:D7, "<>", C2:C7)

et wrote:
> Hi all,
>
> I would like to set a formula in a cell to sum up the value of all nonblank
> cells.
>
> The detail is that I got a data file download from a system, column C
> contains local value and column D contains the USD value, not all the USD
> cells have value because if the bill is originally billed at local currency,
> the USD value is empty, but if the bill is billed at USD, it automatically
> generate a local value in column C. I need the know the total of original
> value of both USD and local.
>
> Column C Column D
> 1000 100
> 200 20
> 350
> 410 41
> 288
> 2350
>
> To get the total value of Col D is easy, simply set sum(D2:D7) at D8.
> To get the total value of Col C, I set sumif(D2:D7, <>"", C2:C6), but it did
> not work.
>
> Anyone can help ?
>
> et
>
>
>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html