Excel : Counting on two columns

  • Thread starter Thread starter adhar jain
  • Start date Start date
A

adhar jain

THIS IS AN MICROSOFT EXCEL QUESTION: URGENT

Suppose I have two columns "A" and "B".
"A" "B"
Error Open
Error Closed
Not Error Open
Error Open
Error Closed
------------------
------------------

----- -> Represents blank rows..

How will I find Error which are open in columns 0-7
(including blank rows)
 
Try putting this into C1

=SUMPRODUCT((A1:A65535="Error")*(B1:B65535="Open"))

Hope it helps,

-Bo
 
You must log in or register to reply here.

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

counting blank cells within two columns 2
Having Blank Cells, etc. ? 1
Cell reference formula problem 5
formula error 1
problem in Excell 2003 4
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel Concatenate with line breaks but ignore blank cells 3
count if colum begins with 5

Back
Top