Help with a count if formula

[pinkbubblegumshoes]

Hi there,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I'm a bit of a learner when it comes to excel and really need some help with some formula's.<o></o>
<o></o>
It’s a bit complicated to put into words but hopefully I will be able to explain it to you.<o></o>
<o> </o>
Firstly I have a number of different service lines but I’ve taken a snap shot of some of the information in one of them.<o></o>
<o> </o>
<o> </o>

<o></o>
<o> </o>
<o>http://s1192.photobucket.com/albums...1/?action=view&current=SpreadsheetExample.jpg<o></o>
</o><o> </o>
I need a formula that says … <o></o>
IF B is “UK - Application Development” and H is marked with a X it will add the number of X’s up for me<o></o>
<o> </o>
AND<o></o>
<o> </o>
IF I has an X in, it will be subtracted from the number of X’s in H (Confused yet? I am) this also needs to be a count of just those in “UK - Application Development” as B will have a number of different service line’s in.<o></o>
<o> </o>
If anyone out there can make any sense of what I’m trying to do it would be a great great help as at the moment we are putting the totals in manually.<o></o>
<o> </o>
Thank you very very much.<o></o>

 

[VoG]

Possibly

=SUMPRODUCT(--(B1:B100="UK - Application Development"),--(H1:H100="X"),--(I1:I100=""))

 

[pinkbubblegumshoes]

Wow that works! That was quick!! I knew it would be easy for someone that knew what they were doing.

Im not sure how it works but it does so its all good.

Do you know the formula for the 2nd one?

Thank you thank you thank you thank you

 

[VoG]

Which 2nd one? That counts where B contains "UK - Application Development", H contains X and I is blank.

 

[pinkbubblegumshoes]

Hi there,

I thought I would need one formula which adds up all the X in UK - Application Development for coloum H and then another formula which takes away the number of X in I from coloum H (again within UK - Application Development) so I have 2 results.

Sorry im a real beginner at excel but really do appreciate your help.

Also, if you dont mind me asking do you know of any home or london based courses where I can learn this type of thing?

Thank