Counting different colums

  • Thread starter Thread starter gadget
  • Start date Start date
G

gadget

I am using this and it works perfectly:

=COUNTIF('Issues Registered'!(P:P,"yes")

But I want it to look in another column as well (Count "Yes" in colum
P and all "1" in column G). What am I doing wrong?

=COUNTIF('Issues Registered'!(P:P,"yes")(g:g,"1"))

Your help will be appreciated

Mike :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

complex CountIf situation 3
Excel Excel list 1
Formula Help 4
countifs criteria includes date range 4
using CountIF function or Array? 3
Counting and multiplying 3
SumIf AND 6
COUNTIF or something else? 9

Back
Top