I need the sum of 1 cell based on another cell which is blan

[afs24]

Trailer Count
56498 20
30
13544 65
16589 100
34163 800
200
13541 100

I'm trying to sum the count only for the count with a trailer # in the cell next to it. I only want those counts. If anyone could provide me with the answer with a formula and another with code it would be appreciated.

 

[Aladin Akyurek]

On 2002-10-03 18:49, afs24 wrote:
Trailer Count
56498 20
30
13544 65
16589 100
34163 800
200
13541 100

I'm trying to sum the count only for the count with a trailer # in the cell next to it. I only want those counts. If anyone could provide me with the answer with a formula and another with code it would be appreciated.

Let A2:B8 house the sample you provided...

Is this what you want:

=SUMPRODUCT(ISNUMBER(A2:A8)+0,B2:B8)

 

[IML]

You may also be able to get away with
=SUMIF(A2:A8,"<>",B2:B8)

good luck