=SUMIFS(field6,field2,"11",field3,"10")
Need a workflow that queries list A
Looks in Field 1 to see if it contains the number 11
And
Looks in Field 2 to see if it contains the number 10
If true it gets the number in Field 6 of that Item ID and stores it.
Then after collecting all in list that meet this fact
Adds them up and stores in a col variable
Then takes that number and puts it in List B Field 2 for this fact.
I have tried the following:
Any Ideas what I am doing wrong?