Results 1 to 12 of 12

Multiply COUNTIF by criteria in same row.

Threaded View

  1. #3
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Multiply COUNTIF by criteria in same row.

    Hi, do you mean counting the "Yes" per code?

    Maybe in M2

    =SUMPRODUCT(($B$2:$B$12=K2)*($C$2:$I$12="Yes"))

    Hope it helps

    Regards

    -----------------

    Sorry: I did not mean to overlap.
    Last edited by canapone; 02-09-2011 at 04:26 PM.

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