 # Help with SUMPRODUCT formula

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

3 Replies

# Re: Help with SUMPRODUCT formula

Did you try third criteria as

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

# Re: Help with SUMPRODUCT formula

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