I have my data in a sheet named "Current"
I am trying to write a formula in a separate sheet that will sum values in column D based on 2 criteria in column G
I am getting a #NAME? error (for Criteria)when I click (fx) into the formula . The result in the cell is shown as zero.
Here is the formula.
=SUMIF(Current!G:G,“Tommy”,Current!D

)+SUMIF(Curr ent!G:G,“Pauline”,Current!D

)
Thanks,
Tommy