#### quiqueperez

##### New Member

- Joined
- Sep 10, 2014

- Messages
- 12

I'm struggling to write a formula to sum the values in column A based on a number of conditions, including one that applies over multiple columns.

Using the following example, I would need to add the values in column A if condition 1 = Australia and the value in at least one of the areas is greater than zero.

In the current example the result woud be 55 (row3 + row4)

VALUES TO ADD | CONDITION 1 | AREA 1 | AREA 2 | AREA 3 |

56 | US | 1 | 0 | 2 |

23 | AUSTRALIA | 0 | 1 | 0 |

32 | AUSTRALIA | 1 | 1 | 2 |

14 | AUSTRALIA | 0 | 0 | 0 |

<tbody>

</tbody>

The formula I'm thinking of is something like this, but I don't know how to formulate it,

SUMIFS(VALUES TO ADD, CONDITION 1, AUSTRALIA, SUM(AREA 1, AREA 2, AREA 3), ">0")

Any would be very much appreciated.

Cheers,

Enrique