Filter and sum

[G-fer]

Hi All...

Gotta problem I hope you can help me with.

Need a VBA solution to the following problem ......

A1 to A5 can only contain text 'Open' or 'Closed'.
B1 to B5 contain an integer.

I would like to sum the B cells that are adjacent to the A cells with value 'Open'.

Any help appreciated.

G-fer

 

[Jon von der Heyden]

=SUMIF(A:A,"open",B:B)

 

[G-fer]

Thanks Jon ..