IF statement followed by a SUM

[Ryan1996]

Hi guys,

I'm trying to create a formula to look into a box and sum up how many of x application are within a certain column.

So for example i have the below

[TABLE="width: 674"]
<tbody>[TR]
[TD]Username[/TD]
[TD]Notes[/TD]
[TD]Resolution[/TD]
[/TR]
[TR]
[TD]User1[/TD]
[TD]This is the notes field where application thisisapplication1 is held as proof for blah[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]User2[/TD]
[TD]This is the notes field where application thisisapplication2 is held as proof for blah[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]User3[/TD]
[TD]This is the notes field where application thisisapplication1 is held as proof for blah[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]User4[/TD]
[TD]This is the notes field where application thisisapplication1 is held as proof for blah[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]User5[/TD]
[TD]This is the notes field where application thisisapplication2 is held as proof for blah[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]User6[/TD]
[TD]This is the notes field where application thisisapplication2 is held as proof for blah[/TD]
[TD]NO[/TD]
[/TR]
</tbody>[/TABLE]

As you can see there are 3 columns, one being a notes box. In a new column i need to search within this box (B2 - the notes column) for either "application1, or "application2" and so on and then if one of those exists i need it to respond with a result so for example application 1 could say "YES", application2 could say "NO" and application3 could say "MAYBE" (these are just examples so i can hopefully get you to understand)

I'm sure this should be a simple IF statement along with AND/OR however i can't seem to get it to work.

If anyone can help that would be great!

 

[Joe4]

Here is one way:

=IF(ISNUMBER(FIND("application1",B2)),"YES",IF(ISNUMBER(FIND("application2",B2)),"NO",IF(ISNUMBER(FIND("application3",B2)),"MAYBE","")))

 

[Ryan1996]

I figured out all i really needed was a countif bit of code and didn't need all the extra but i'm definitely going to use this anyway, very very helpful!