IF statements.. long

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: nca77 (nca77.15wkkm_at_excelforum-nospam.com)
Date: 05/07/04

  • Next message: Shaz: "Delete Work*** and replace/delete links" 
    Date: Fri, 7 May 2004 15:28:00 -0500

    hello,

    Column A has interest rates
    Column B has volumes
    Column C has dates

    Row 1 (starting in column E) has month end dates from April 30, 2004 -
    April 30, 2010

    each month i need to paste new data into columns A - C and i need a
    formula to put into row 2 below the month end dates that will try to
    match the months and years in column C to the months and years in Row
    1. If they match, I need the formula to take the interest rates in row
    A times the volumes in Row B and divide that results by the sum of the
    volumes in row C that match the months and years in row 1.

    I'm sure this is a "sumproduct" formula but im having trouble with the
    "IF" statement part of it.

    Thanks in advance

    Nick 

    ---
Message posted from http://www.ExcelForum.com/
  • Next message: Shaz: "Delete Work*** and replace/delete links"
    • Quantcast