COUNTIF to many arguments

**Nick.123** · 05-02-2011, 12:12 PM

Hi, Trying to use countif to count the work Wifi in two columns however I keep getting message stating to many arguments.

=COUNTIF(D:D,K:K,"*WiFi*")

Is there some way to do this.

Cheers
Nick

**alansidman** · 05-02-2011, 12:27 PM

The COUNTIF function does not support multiple ranges. However, you could try summing multiple COUNTIFs.

For example:

=SUM(COUNTIF(D:D,"*Wifi*"),COUNTIF(K:K,"*Wifi*"))

**Nick.123** · 05-02-2011, 12:31 PM

Thanks that done the trick :D

**tcopling** · 05-03-2011, 01:42 PM

Hello,
I am working with a sheet that sums up a percentage. I want to create a report that has if >30% then checked (and summed) if <30% (blank)
I am a novice at best and not sure how to create the data from the sheet that is populated on a daily basis. I've attached the sheet and the last tab was were I was going to put in the reports by person and by department. Any help would be greatly appreciated.

Tom

**NBVC** · 05-03-2011, 01:49 PM

Welcome to the forum,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.