Associate
- Joined
- 24 Jul 2009
- Posts
- 2,252
- Location
- -
Hi, might be an easy answer but I cannot figure this out.
I have a list of numbers formatted in GBP in one column. Next to this I have another column and in some of these are the letters 'CR'. I need a formula that will only add up the values that have CR next to them. Is that possible? I have tried with counta and counfif but cannot get it to work.
I have a list of numbers formatted in GBP in one column. Next to this I have another column and in some of these are the letters 'CR'. I need a formula that will only add up the values that have CR next to them. Is that possible? I have tried with counta and counfif but cannot get it to work.
Code:
£199.99
£5.01
£270.69 CR
£5.01 CR
£125.00 CR
£91.27
£19.00
£30.00
£19.00 CR
£120.00 CR
£85.00
£125.00 CR
£58.56 CR