Results 1 to 4 of 4

Problem with If and sumproduct formulas

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Problem with If and sumproduct formulas

    Hi,

    I have a sheet that contains rows containing letter codes for example "CU". This is generated by an IF formula i.e. If true = "CU". However I need to be able to calculate the number of instances of "CU" but sumproduct will not work as it sees the cell as containing a formula not the result i.e. "CU".

    Sumproduct code:

    =SUMPRODUCT(D58:D61="CU")
    If code:

    =IF($A58="","",IF(D$5="RD","RD","CU"))
    Thanks in advance
    Last edited by jpruffle; 03-30-2009 at 06:07 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