Help with Excel SUMIF Formula

		Microsoft Office Forums > Microsoft Excel > Excel
Help with Excel SUMIF Formula

FAQ

Thread Tools

Display Modes

12-08-2023, 03:42 AM

tomohawk

Windows 10 Help with Excel SUMIF Formula

Office 2019

Advanced Beginner

Join Date: Sep 2020

Location: Dublin

Posts: 64

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel function sumif help	ganesang	Excel	8	09-05-2021 08:53 PM
Data connection problem excel/sharepoint using an SUMIF array	mwestra74	Excel Programming	10	11-28-2017 06:26 PM
Using SUMIF when criteria is a formula	SLCREW	Excel	5	02-22-2017 10:21 AM
SUMIF Formula question	jcaswell	Excel	3	05-22-2011 02:52 AM
Need Help With SUMIF Formula In R1C1 Style	Todd	Excel	9	02-27-2010 08:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:20 AM.