Help with SUMPRODUCT formula

[victoria615]

I am trying to count the number of columns that meet three specified criteria using the SUMPRODUCT function. The columns contain the following variables  A = location(String), D = New or Existing(string), F = old allocation (integer), G = new allocation (integer)

SUMPRODUCT(('Allocation>Specials'!A:A = $A24)*('Allocation>Specials'!D:D = $C$23)*('Allocation>Specials'!F:F > 'Allocation>Specials'!G:G))

I want the third criteria to read > 2*the values in G: G. Is SUM product the right formula, if yes, how do I count the values in column F that are greater than 2 times the value in column G.

If NO what other ways can I count the number of variables that meet the criteria

@members

[#2]

@victoria615 Hey Please attach your excel File for example

[#3]

@victoria615 

Did you try third criteria as

('Allocation>Specials'!F:F > 2*'Allocation>Specials'!G:G)

[#4]

Try this:
=SUMPRODUCT((‘Allocation>Specials’!A:A=A24)*
(‘Allocation>Specials’!D:D=C23)*
(‘Allocation>Specials’!F:F>2*’Allocation>Specials’!G:G))