Monday, November 19, 2012

yogi_WorkAround For COUNTIFS In Excel For MultiCriteria Count In Google Spreadsheet

                                          Google Spreadsheet   Post  #874
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 19, 2012

I created this illustration in response to a question by user K in my blog post:
yogi_Workaround For Countifs Function In Google Spreadsheet
http://yogi--anand-consulting.blogspot.com/2012/04/yogiworkaround-for-countifs-function-in.html
---------------------------------------------------------------------

5 comments:

  1. This is not helping..

    What I actually wanted is

    The number of tickets with ColumnA as Network, Coloumn B as Incident and Coloumn C as Closed.

    ReplyDelete
    Replies
    1. To make it simple..can we have equivalent formula for countifs for 3 conditions matching?

      Delete
  2. Hi K:

    I have updated the solution in my blog post for the specification in your last comment.

    Cheers!
    Yogi

    ReplyDelete
  3. You Are Very Welcome K ... Now Let Us keep Googling.

    Cheers!
    Yogi

    ReplyDelete