sumifs

Here’s another way: EDIT – updated to add “averageifs” and “sumifs” to my initial (mistaken) “countifs” version… Sub SetupDummyData() Const NUM As Long = 100001 Range(“A1:E1”).Value = Array(“A_Header”, “B_Header”, “C_Header”, “Value”, “ResultHere”) Range(“A2:A” & NUM).Formula = “=””A#”” & round(RAND()*10,0)” Range(“B2:B” & NUM).Formula = “=””B#”” & round(RAND()*10,0)” Range(“C2:C” & NUM).Formula = “=””C#”” & round(RAND()*10,0)” Range(“D2:D” & … Read more