P
Pete Derkowski
Hi - some years ago I needed a formula that would count rows where certain
columns were certain values.
ie. in english, it'd be something like if col a = 1 and col d <8000 and
col f > 5 then count the row.
Someone sent me a SUMPRODUCT ( I think it was that) formula that did the
trick.
I can't find that formula - the xls file it was in is now gone, and once I
again I need the same type of formula.
I can't use DCOUNT since the cols to check are not sequential (next to
eachother).
Anyone know the trick of using SUMPRODUCT or some other formula (in case I
remember is wrong)?
Pete
columns were certain values.
ie. in english, it'd be something like if col a = 1 and col d <8000 and
col f > 5 then count the row.
Someone sent me a SUMPRODUCT ( I think it was that) formula that did the
trick.
I can't find that formula - the xls file it was in is now gone, and once I
again I need the same type of formula.
I can't use DCOUNT since the cols to check are not sequential (next to
eachother).
Anyone know the trick of using SUMPRODUCT or some other formula (in case I
remember is wrong)?
Pete
1000<8000),--(F1:F1000>5))