Sum values using cell with varying values

[dmullen]

I have two columns, one with numeric values that I would like to sum if the
value in the second column is not null. The values of the second column are
either an 'X', a date (mm/dd) or blank.

 

[Dave Peterson]

This will sum A1:A20 if B1:B20 is non-blank:

=SUMIF(B1:B20,"<>",A1:A20)

 

[duane]

adjust the c6:c8 for your column of x's and dates, and b6:b8 for you
column of data

=SUMPRODUCT((NOT(ISBLANK(C6:C8)))*(B6:B8)

 

[dmullen]

Works!

Thanks a lot.

This will sum A1:A20 if B1:B20 is non-blank:

=SUMIF(B1:B20,"<>",A1:A20)

 

[dmullen]

This also works. Thanks for the second method!