how can I count if column A="active" and column E="Job" in a list?

G

Guest

Basically have a spreadsheet of info on current jobs. On sheet 2 i would
like a count of active jobs.

On Sheet 1 data is laid out as follows:
Column A = "a" or blank
Column E = "J" or "S" or blank

The problem is that old jobs are also in the sheet. So countif(E:E,"J")
returns all the j's even if the job is no longer active (Column A is blank,
but column E has a "J").

Formula needed is: If Col A="a" and column E="J" then count.

Basically want to find number of Js when column A ="a". I can use Countif
for number of "a'"s but can't figure out how to condition a formula to count
the "j" in only the rows with a corresponding "a" in column A.

Thank you for your help!
 

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

how can I count if column A="active" and column E="Job"? 6
Excell - two conditions count if factors are true when negative nu 2
COUNTIF for 2 columns 6
How to count a coloum if two conditions are met 5
Count cells based upon criteria in other cells 13
Excel How to count from a column if specific condition in another column is true 3
Countif, plus ? 8
Count values in column only if value of another column is true 4

Top