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
Bookmarks