Hey,

Sorry if this is a basic question, but I've been using calc for a few years and I always been able to find the answers, but I don't really know how to search this.

So, I want to use a IF condition like this:

If the value of the column A is 'x' then i want the correspondent value of B to be added.

Example:

Column A:

A1.Dog

A2.Cat

A3.Dog

A4.Cat

A5.Cat

(...)

Column B:

B1.1

B2.2

B3.1

B4.1

B5.0

(...)

So, IF in A you have "Dog" then i want the sum of the Column B value.

In this case would be B1 + B3 the answer.

Not sure if i explained myself properly, but if you guys can help me, that would be great.