Count using multiple conditions.

[ThrottleWorks]

Hi,


I have three columns, A, B & C


Column A has both the blank & non blank values


Column B has values as 1 2 3 4 can go to 5, 6 but not now


Column C has text values such as complete, incomplete, WIP, reject


I want to design a formula in another table.


Following is the example of table 1.


Cell G1 value (header) complete

Cell G2, H2, I2, J2 value (header) 1,2,3,4


In cell G3 the formula should give me count of values as below

It will check if the cell a2 is non blank

If the cell B2 value is 1

If the cell C2 value is complete


The formula will check these condition for the entire column & will give the count in a single cell.


For example I have 50 non blank cells in column A

I have 40 cells in B column which has value as 1

I have 30 cells in column C which has value as complete


So the cell G3 should give me result 30.


Can anyone help me in this please.

 

[ThrottleWorks]

Done ! used Countifs, have a nice day.

 

[shrivallabha]

Also try Pivot Table which can do this quickly.

 

[ThrottleWorks]

Hi Shrivallabha ji, thanks a lot for the help.


Can not use pivot table, sorry for late reply.


Have a nice day.