+ Reply to Thread
Results 1 to 13 of 13

Problem with function for count with criteria

Hybrid View

  1. #1
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    I want to count the instances in B where criterion of A is met, not the sum of the numbers in the rows.
    Our responses have been based on the above. If you want a sum, =SUMPRODUCT(('Master log'!K:K>'Master log'!L:L)*('Master log'!D:D="HJT"),'Master log'!K:K) and =SUMPRODUCT(('Master log'!K:K<'Master log'!L:L)*('Master log'!D:D="HJT"),'Master log'!L:L). Again, either the first will have to be >= or the second <= to account for instances in which they're equal.

  2. #2
    Registered User
    Join Date
    03-23-2008
    Posts
    9
    Thanks a tonne!! Really appreciate your time and effort ...not to mention the patience.

+ Reply to Thread

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