Results 1 to 2 of 2

sumproduct formula to count keyword in cells for a given month

Threaded View

  1. #1
    Registered User
    Join Date
    01-12-2011
    Location
    Yeovil, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    sumproduct formula to count keyword in cells for a given month

    =SUMPRODUCT(--(MONTH('Short Term Issues'!$A$2:$A$100)=11),--(YEAR('Short Term Issues'!$A$2:$A$100)=2010),--('Short Term Issues'!$D$2:$D$100="Leaking"))

    Im using the above formula to count rows which have the information 'Leaking' contained in column D:D where the date raised in column A:A is within a certain month, in this case 'Nov2010' - Ill be duplicating the formula for subsequent months, and differant key words in other cells

    My problem is that this formula only counts cells which are an exact match of the keyword. Can this be modified so that it counts cells where other words are present along with the keyword?? I have tried using a wildcard type function but iv been unsuccessful so far.

    Any helps is appreciated, Thanks
    Last edited by philllipoosis; 01-13-2011 at 10:52 AM. Reason: moderator instructions

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