Addition of two Column with Condition

  • Thread starter Thread starter Tayyab
  • Start date Start date
T

Tayyab

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

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))
 
Back
Top