D
D
Daniil Chepenko2015-10-07 13:37:58
Google Sheets
Daniil Chepenko, 2015-10-07 13:37:58

How to make COUNTIF based on adjacent column condition?

Good afternoon!
I made a questionnaire, got the results, now I want to play a little with the data, build charts, graphs, and so on.
The standard Summary does not suit me.
I want to know which factor is the most determining for the owner of a specific application
61c03bfaf0f24c5a9d93df9009dedd78.png
. Tobish, I want to summarize column J by the value "Cost of the trip", provided that, in column I, the value is "Yandex.Taxi"
I wrote such a formula, but it gives strange numbers
=IF (' Form Responses 1'!I:I = "Yandex.Taxi", COUNTIF('Form Responses 1'!J:J, "Travel cost"), "Error")
Is it even possible to perform such an operation in Google Doc? I really don’t want to go to Excel, but such an operation would be very useful in the future.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2015-10-08
@zkid

Most likely you need the formula COUNTIFS()
For example,

=COUNTIFS(A2:A9,"=Яндекс.Такси",B2:B9,"=Стоимость")

Sample Table with Select Fields
2ff795ba82e44844a2e99880c6ea9ee5.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question