Addition of two Column with Condition

[Tayyab]

Hi
I need a formula that calculate two or more column with given
condition, I used SUMIF and DSUM , but it cant worked.

 

[joeu2004]

I need a formula that calculate two or more column with given
condition, I used SUMIF and DSUM , but it cant worked.

Difficult to answer without a specific example. Perhaps one of the
following will help:

=SUMIF(A1:A100,"<100",B1:B100)+SUMIF(A1:A100,"<100",C1:C100)

or

=SUMPRODUCT((A1:A100<100)*(B1:C100))