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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Take an average of data where lookup in array is needed 3
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
IF, AND & OR 3
error in highlighting duplicate values in excel 1
Sumif all Null Values 8
Excel VBA 1
Conditional Formulas 5
2nd condition in a conditional formatting not working 9

Back
Top