Converting formula to VBA worksheetfunction variable

[WednesdayC]

Hi All

Can anyone help me please

I have the following formula:-

WS.Cells(20, 1).Formula = _
"=IFERROR(SUM(SUMIF('RESULT ONE'!A2:A1000,{""*EMPLOYEE*"",""*FREELANCE*""},'RESULT ONE'!e2:e1000)),"""")"

I am trying to convert this formula so it works in VBA and the result is posted to a variable instead. I have tried different permutations but I just can't get this right

So assuming V is my variable - I want something like V = worksheetfunction.sum etc

I am using Excel 2016 (for Mac)

Many thanks in advance

Wednesday

 

[Fluff]

Try

   Dim x As Variant
   x = Evaluate("SUM(SUMIF('RESULT ONE'!A2:A1000,{""*EMPLOYEE*"",""*FREELANCE*""},'RESULT ONE'!e2:e1000))")

 

[WednesdayC]

Dim x As Variant
x = Evaluate("SUM(SUMIF('RESULT ONE'!A2:A1000,{""*EMPLOYEE*"",""*FREELANCE*""},'RESULT ONE'!e2:e1000))")

Hi Fluff

Brilliant! Yet again, thanks so much for your help.

Regards

Wednesday

 

[Fluff]

You're welcome & thanks for the feedback.