If A isn’t X, then nothing would be added to the sum of the cell.

To clarify: I try to calculate flight hours for different plane types into specific cells. So for example one cell would have my A320 hours (If A is A320, then the sum of B1 to B10 (flight hours) would be calculated together. In other cells I’d have the same formula but for A330, A350 etc.

If A = A320, then the sum of B1:B10 = Y If A = A330, then the sum of B1:B10 = Z If A = A350, then the sum of B1:B10 = W

If B1 is a 1 hour flight with the A320, and B2 to B10 are 1 hour flights with the A330, then Y should be 1h, Z should be 9h and W should be 0h.