Offset sum based on criteria

[anthgav]

Can anyone help with this formula, for every cell in column A that has the number 8 I would like to sum the cells next to it in column B. Thanks



8 2
2 5
3 -3
8 4
1 1
2 3
8 1
3 1
8 1
2 -3

[mdbct]

Please Login or Register  to view this content.

[martindwilson]

=sumif(a:a,8,b:b) snap!

[anthgav]

As simple as that, thanks very much it works a treat!