Results 1 to 7 of 7

make a sumif formula dynamic

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-12-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    448

    make a sumif formula dynamic

    Hello. Any suggestion on how I can make the following formula dynamic? In E4 and beyond I have a formula that will change the cell from "estimate" to "actual" when I insert a tab with actuals information. Currently in the C column, I have the formula below running through January, because that is what I have actuals through. I would like to make this dynamic so that when actuals comes in, the formula below calculates for two months instead of just one. Thank you.


    =IFERROR(SUM($E16)/(SUMIF($B$15:$B$66,$B16,$E$15:E$66)),0%)
    Attached Files Attached Files

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