Results 1 to 11 of 11

Thread: 16147060 PCM Information $85

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-25-2024 #11
    dave w
    dave w is offline
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,344
    Quote Originally Posted by EagleMark View Post
    $85 16147060 VE correction Calculator Spreadsheet
    Updated VE Correction Excel Spreadsheet with Avereragifs for Closed Loop Only.

    Sample Open-Source formulas:

    =AVERAGEIFS('Pasted CSV'!BE:BE,'Pasted CSV'!CN:CN,">=37.5",'Pasted CSV'!CN:CN,"<=42.49",'Pasted CSV'!BX:BX,">=0",'Pasted CSV'!BX:BX,"<=199",'Pasted CSV'!CM:CM,"=closed")

    =COUNTIFS('Pasted CSV'!CN:CN,">=37.5",'Pasted CSV'!CN:CN,"<=42.49",'Pasted CSV'!BX:BX,">=0",'Pasted CSV'!BX:BX,"<=199",'Pasted CSV'!CM:CM,"=closed")



    16147060 VE Corrections.jpg

    Averageifs_01.JPG

    Averageifs_02.jpg
    Attached Files Attached Files
    Last edited by dave w; 03-26-2024 at 03:56 PM.
    Reply With Quote Reply With Quote
« 16159278 ECM Information $DA2 $DA3 | 16146299 ECM Information $99 »

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
  •  

Forum Rules