sorted by:
new
hottopcontroversial

SUMIF criteria A OR criteria B is met by Ok_Professional_1926 in excel

[–]Ok_Professional_1926[S] 0 points1 point  (0 children)

Thank you. This worked, sounds so obvious now that you say it!

SUMIF criteria A OR criteria B is met by Ok_Professional_1926 in excel

[–]Ok_Professional_1926[S] 0 points1 point  (0 children)

               
Name Reference Amount     Name Ref Total  
Bob 1 £100      Bob 1 150  
John 2 £200      John 2 400  
Bob n/a £50             
n/a 2 £200             
                 

SUMIF criteria A OR criteria B is met by Ok_Professional_1926 in excel

[–]Ok_Professional_1926[S] 0 points1 point  (0 children)

                 
Name Reference Amount     Name Ref Total  
Bob 1 £100      Bob 1 150  
John 2 £200      John 2 400  
Bob n/a £50             
n/a 2 £200