How to count non blank cells using countifs

[ThrottleWorks]

Hi,


I want to write a countifs formula.

I have posted something similar earlier.


But this time I want the resolution in a different way that is why I am posting it as a new thread.


http://chandoo.org/forums/topic/count-using-multiple-conditions


I have three columns, A, B & C

Column A & B have blank & non blank values.


Column C has status, say complete, pending, wip


I do not know how to count non blank cells in a countifs formula.

I think I have to use * key & <> “”, but I am not getting it right.


For example.

Column A non blank values = 50

Column B non blank values = 40

Column C “Complete” = 30


So the countifs formula should give me count as 30.

Can anyone help me in this please.

 

[Debraj]

Hi Sachin,


Did you ever tried to cheat EXCEL.. then do it right now..

=COUNTIFS(A1:A35,"<>",B1:B35,"<>",C1:C35,"Complete")

Regards,

Deb

 

[ThrottleWorks]

Hi Debraj Sir,


Thanks a lot for the help, this is amazing.


Have a nice day.

 

[ThrottleWorks]

Sir, honestly I am not able to understand this.


If you get time, could you please explain it, at present it seems magic to me.

 

[Debraj]

Hi Sachin,


Actually its just a trick.. something like, NOT or "="&"Blank"..


Hope the Magic is revealed now..


Regards,

Deb

 

[ThrottleWorks]

Hi Debraj Sir, thanks for your help & valuable time.


Have a nice day.