Count with and function

**ravininave** · 12-05-2015, 07:12 AM

Hi,
I've Date in A1 to A20 Cell Range , Names in B1 to B20 Cell and Amount in C1 to C20

I have to count no of names who don't have date AND whose names >0
secondly sum(Amount) who meet this criteria

for that I tried this
=COUNTIF(A1:A20,"",B1:B20,"*")
But it says you have entered too many arguments for this function
How to do this?

**Alf** · 12-05-2015, 07:39 AM

Try changing "COUNTIF" to "COUNTIFS"

Alf

**Tony Valko** · 12-05-2015, 07:45 AM

What does "whose names >0" mean?

Does that mean if the corresponding cell in column C is >0?

You aren't testing that condition in your formula.

If you're using Excel 2007 or later you need to use the COUNTIFS/SUMIFS functions.

Here's your current formula in the COUNTIFS function:

=COUNTIFS(A1:A20,"",B1:B20,"*")

It means:

Count the cells in A1:A20 that are blank AND the corresponding cells in B1:B20 if they contain any TEXT value.

**ravininave** · 12-05-2015, 04:45 PM

Hello Tony,
Yes it works now. But how to make a sum of C Row with this criteria

**JohnTopley** · 12-05-2015, 05:06 PM

Use SUMIFS function

=SUMIFS(C1:C20,A1:A20,"",B1:B20,"*")

Count with and function

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Count with and function

Re: Count with and function

Re: Count with and function

Re: Count with and function

Re: Count with and function

Thread Information

Users Browsing this Thread

Similar Threads

How to count text entered with ALT+ENTER using a count function

[SOLVED] COUNT function does not count values beginning with text

[SOLVED] Count If Function To Count Frequency Of Long Numbers

Using the COUNT function to count letters generated by an IF function

Count function to count from a set point on recurring basis

Count Formula-Would this be a good example to use the count function?

Count If-How can I use the COUNTIF function to count

Bookmarks

Bookmarks

Posting Permissions