G
Guest
I have spreadsheet that contains the following info: column G contains # of
employees and column K contains revenue, basically I want to see how many
accts have less than $1000 in revenue and between 1 and 9 employees
I used the following but it didn't work:
=SUMPRODUCT(--($G$2:$G$1179>0),--($G$2:$G$1179<10),--($K$2:$K$1179<1000))
I keep getting zero???
employees and column K contains revenue, basically I want to see how many
accts have less than $1000 in revenue and between 1 and 9 employees
I used the following but it didn't work:
=SUMPRODUCT(--($G$2:$G$1179>0),--($G$2:$G$1179<10),--($K$2:$K$1179<1000))
I keep getting zero???