ExcelAtEverything
Active Member
 Joined
 Jan 30, 2021
 Messages
 308
 Office Version

 2019
 Platform

 Windows
Hello,
Could someone help me with my SUMIF criteria?
What I want is: Sum as many items in the GS$ column as their are in the GS Comp % (Like vs Like) column.
The problem is that there are formulas in each of these cells, and my SUMIF below is counting the formulas that are in the "empty" cells in column I as values. So instead of this summing only G16 & G17, it's summing G16:G19. I've tried a few alternatives after some internet searches, but can't seem to get it to work. Is the answer to just do a combination If/SUMPRODUCT formula (since if not not mistaken, SUMPRODUCT does not recognize formulas as values)?
Thanks!
=SUMIFS([GS$],[GS Comp %],"<>")
Could someone help me with my SUMIF criteria?
What I want is: Sum as many items in the GS$ column as their are in the GS Comp % (Like vs Like) column.
The problem is that there are formulas in each of these cells, and my SUMIF below is counting the formulas that are in the "empty" cells in column I as values. So instead of this summing only G16 & G17, it's summing G16:G19. I've tried a few alternatives after some internet searches, but can't seem to get it to work. Is the answer to just do a combination If/SUMPRODUCT formula (since if not not mistaken, SUMPRODUCT does not recognize formulas as values)?
Thanks!
=SUMIFS([GS$],[GS Comp %],"<>")