route217
asked on
sumproduct or sun if formula
Hi Experts
Need a formula to do the following:
Column A Column B Column C
England 12 1
Look in column A if the text is england and the value in column c is 1 then return the same of the values in column B...
Need a formula to do the following:
Column A Column B Column C
England 12 1
Look in column A if the text is england and the value in column c is 1 then return the same of the values in column B...
ASKER
hi experts
this does not give me the value in column b
this does not give me the value in column b
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sorry if I was not clear I want to show the value 12 in column d...
whichever cell you put that formula in should display the value in B if it meets the criteria.
=IF(AND(A2="England",C2=1)
happy coding