• Status: Solved
• Priority: Medium
• Security: Public
• Views: 310

# 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...
0
route217
• 3
• 2
1 Solution

Commented:
I think this formula will work for you

=IF(AND(A2="England",C2=1),B2,"No Result")

happy coding
0

Author Commented:
hi experts
this does not give me the value in column b
0

Commented:

=IF(AND(UCASE(A2)="ENGLAND",C2=1),B2,"No Result")

assuming you are on row 2 of course.
if not replace 2 for the row you are evaluating
0

Author Commented:
sorry if I was not clear I want to show the value 12 in column d...
0

Commented:
whichever cell you put that formula in should display the value in B if it meets the criteria.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

## Featured Post

• 3
• 2
Tackle projects and never again get stuck behind a technical roadblock.