Countif

**trixxnixon** · 04-02-2009, 01:13 PM

i need to count based on 2 seperate sets of criteria in the same row.

column G houses the total number of hits as a number,
Column E holds the division
Column B holds the job title,

rows 2 through 222

i need to sum up the numbers in each G field, where the G and E field match a specific text criteria.

is this possible with sum if or count if?

**NBVC** · 04-02-2009, 01:24 PM

You need Sumproduct()

e.g.

=Sumproduct(--(B2:B100="B_Criteria"),--(E2:E100="E_Criteria),G2:G100)

**trixxnixon** · 04-02-2009, 01:43 PM

thank you, i will try sum product,
i was trying to use this as suggested elsewhere, but have not gotten it to work.

IF((E$2:E$222="New Business"),SUMIF(B$2:B$222,"Account Relations Executive",G$2:G$222),"0" )

**NBVC** · 04-02-2009, 01:45 PM

Not show who suggested that but I don't think it will work for what I think you are wanting to accomplish....

Note: If you post same question in multiple forums, you need to provide the links as per our forum rules.

**trixxnixon** · 04-02-2009, 01:53 PM

Originally Posted by NBVC

Not show who suggested that but I don't think it will work for what I think you are wanting to accomplish....

Note: If you post same question in multiple forums, you need to provide the links as per our forum rules.

i read it on another forum, from another post.

**NBVC** · 04-02-2009, 02:22 PM

Originally Posted by trixxnixon

i read it on another forum, from another post.

Ok thanks...

Let us know how it works out.

**trixxnixon** · 04-02-2009, 04:16 PM

Originally Posted by NBVC

Ok thanks...

Let us know how it works out.

i ended up using the concentrate function, and then using a sum if function.
i couldnt figure out for the life of me how to get the other to work

Thanks for all of your help