Jun 25 2020 06:46 AM
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
Jun 25 2020 07:49 AM
@victoria615 Hey Please attach your excel File for example
Jun 25 2020 08:34 AM
Did you try third criteria as
('Allocation>Specials'!F:F > 2*'Allocation>Specials'!G:G)
Jun 25 2020 10:53 AM