Countif Formula

**powerade1985** · 02-04-2014, 03:57 AM

Hi Everyone,

I need someone's help with a problem I have with a forumla =COUNTIF(J3:J152,"henlow")+COUNTIF(K3:K152,"e1")

I need to count two different ranges containing words. For example I ONLY want it to count place "henlow" and the persons rank "E1" I dont want it to count other places and other matching ranks.

I'm using Excel 2003.

I'm grateful if anyone could help.

Many Thanks

**Fotis1991** · 02-04-2014, 03:59 AM

Try

Formula:

Please Login or Register  to view this content.

**powerade1985** · 02-04-2014, 04:04 AM

Hi Fotis,

It says it contains an error.

Thanks for trying

**Fotis1991** · 02-04-2014, 04:07 AM

Isn't E1 a cell reference??

Then...

Formula:

Please Login or Register  to view this content.

**bebo021999** · 02-04-2014, 04:07 AM

Maybe:
=SUMPRODUCT((J3:J152="henlow")*(K3:K152="e1"))

**powerade1985** · 02-04-2014, 04:10 AM

Thanks everyone and many thanks to bebo021999 that worked.

Countif Formula

LinkBack

Thread Tools

Rate This Thread

Display

Countif Formula

Re: Countif Formula

Re: Countif Formula

Re: Countif Formula

Re: Countif Formula

Re: Countif Formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] CountIf formula results in the formula itself being displayed.

[SOLVED] Using Countif formula on cells that have a Left formula

[SOLVED] =Subtotal(countif,Range); Subtotal and countif in 1 formula [SOLVED]

Countif formula help please

Adding a CountIF to a formula that is already Countif

Bookmarks

Bookmarks

Posting Permissions