Answer the question
In order to leave comments, you need to log in
How to sum cells by condition in another cell?
Good afternoon!
I can't write the formula.
Example:
If in column "a" after an integer there are fractional numbers (for example, 3 and after it 3.1), then the numbers in column "c" should be summed up in a column with an integer.
Example in screenshots:
What is -
What is needed -
Answer the question
In order to leave comments, you need to log in
Just add the condition you described in the question.
=IF(AND(A1<>"";INT(A1)-A1=0);B1*D1;"")
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question