Sumif Help - two columns

Hello everyone

I have two columns with number values in them. I want to sum only those cells which have a value in the equivalent cell in the next column.

Thanks in advance.

Without an example file to show your data layout it's impossible to give an exact answer, but the below will sum the values in column A where column B is not blank.
=SUMIF(B:B,"<>",A:A")

Does that help?

BSB

=sumproduct((a1:a10=b1:b10)*(a1:a10)) if the values have to be equal otherwise the solution in the post above

or, possibly, to aggregate numerics in either A and/or B - but only where both A & B are populated

Formula:

Please Login or Register  to view this content.

modify range to suit but do not use above with entire column references.