=COUNTIF(C6:C7(EXACT(C6,"Su"),EXACT(C7,"Su")),="Su")

**adamwestrop** · 07-30-2011, 12:03 PM

=COUNTIF(C6:C7(EXACT(C6,"Su"),EXACT(C7,"Su")),="Su")

Why wont this formula work?

What mistake am I making please?

Thanks

**Sadath31** · 07-30-2011, 12:09 PM

try this
=SUMPRODUCT(--EXACT(C6:C7,"Su"))

**adamwestrop** · 07-30-2011, 12:15 PM

Hi, thanks but im not looking for the answer to a specific solution, I want to see where I am going wrong in the forumula string :-

=COUNTIF(C6:C7(EXACT(C6,"Su"),EXACT(C7,"Su")),="Su")

**daddylonglegs** · 07-30-2011, 12:28 PM

Can you describe in words what you want to do?

The first argument of COUNTIF must be a range, C6:C7(EXACT(C6,"Su") isn't a range

**JBeaucaire** · 07-30-2011, 12:32 PM

Originally Posted by adamwestrop

....I want to see where I am going wrong in the forumula string :-

=COUNTIF(C6:C7(EXACT(C6,"Su"),EXACT(C7,"Su")),="Su")

DaddyLongLegs is right about what's wrong with the formula first parameter has to be a range, not a test.

But I underlined the answer to your question "where am I going wrong?". You're using the wrong function. Sadath pointed to the correct function to use in Excel 2003, SUMPRODUCT(). In Excel 2007+ you would use COUNTIFS().

**adamwestrop** · 07-30-2011, 12:41 PM

Sorry,

Just messing round with formulas,

OK amending to this then:-

=COUNTIF(C6:C7,(EXACT(C6,"Su"),EXACT(C7,"Su"))

Why isn't this working?

Thanks

**JBeaucaire** · 07-30-2011, 12:44 PM

=COUNTIF(C6:C7, "Su")

Press F1 in Excel and read up on the CountIf function.

**daddylonglegs** · 07-30-2011, 12:46 PM

With respect, adam, you need to describe what you want to do, why are you using EXACT? that's normally used when you want a case-sensitive count - is that the case here?

**adamwestrop** · 07-30-2011, 12:56 PM

Sorry for the confusion guys, im trying to learn the basics on formula strings, and what a formula should be. Im not really trying to accompolish anything, just messing around.

=COUNTIF(C6:C7,(EXACT(C6,"Su"),EXACT(C7,"Su"),"Su")

This I thought with Count the cells C6 & C7 if the contents of those cells were exactly "Su".

Again apologies for the confusion, I am really trying to get a handle on combining forumla etc and what formula strings should look like etc.

Im trying to keep my worksheets very atomic by nature, so shouldn't have need for any complex formulas, however will be good to learn putting forumlas together and when I need to use certain strings etc.

Thanks

**daddylonglegs** · 07-30-2011, 04:10 PM

Jerry's formula should do that for you (I assume C6 and C7 are text values not formatted dates). It isn't case-sensitive.

Sadath's does the same.....but that is case-sensitive so it won't count SU or su for instance. For the case-sensitive version you need to use SUMPRODUCT because COUNTIF doesn't allow you to manipulate the range.