D
DevonDilema
Hi,
I need to lookup values in two columns and where matches are found, SUM a
numeric in a third column. The below data probably explains it better:-
A B C
Name yes or no Total
Joe yes 7
Adam yes 1
David yes 5
Joe yes 3
Joe no 4
Adam yes 3
D1=Joe
E1=yes
Where column A ='Joe' and column B='yes' then SUM the content of column C.
So in this case it would return '10' (i.e. 7+3).
Many thanks
I need to lookup values in two columns and where matches are found, SUM a
numeric in a third column. The below data probably explains it better:-
A B C
Name yes or no Total
Joe yes 7
Adam yes 1
David yes 5
Joe yes 3
Joe no 4
Adam yes 3
D1=Joe
E1=yes
Where column A ='Joe' and column B='yes' then SUM the content of column C.
So in this case it would return '10' (i.e. 7+3).
Many thanks