S
S
SETxd2021-12-16 14:53:43
Google Sheets
SETxd, 2021-12-16 14:53:43

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 - 61bb26e61b6a2967408225.png

What is needed -61bb280f42059511350018.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
dollar, 2021-12-16
@SETxd

Just add the condition you described in the question.
=IF(AND(A1<>"";INT(A1)-A1=0);B1*D1;"")

A
Alexander, 2021-12-16
@ForestAndGarden

A7 / WHOLE(A7) = 1
A8 / WHOLE(A8) ≠ 1
Got it?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question