Results 1 to 6 of 6

Count number of rows with multiple criteria

Threaded View

  1. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Count number of rows with multiple criteria

    Based on your example:

    =SUMPRODUCT(($B$2:$P$2=$C$37)*($B$3:$P$3=$C$36)*SIGN(SUBTOTAL(9;OFFSET($B$4;ROW($B$4:$B$33)-ROW($B$4);COLUMN($B$4:$P$4)-COLUMN(B4)))))

    where C36 holds "Ext" & C37 holds 21.

    translate SUMPRODUCT, SIGN, OFFSET, ROW & COLUMN as and if appropriate (SUMPRODUKT, FORTEGN, FORSKYDNING, RĘKKE & KOLONNE)
    Last edited by DonkeyOte; 09-17-2010 at 05:21 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1