View Single Post
 
Old 12-08-2023, 03:42 AM
tomohawk tomohawk is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Sep 2020
Location: Dublin
Posts: 62
tomohawk is on a distinguished road
Default Help with Excel SUMIF Formula

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
Reply With Quote