Formula Help
 

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$11790),--($G$2:$G$1179<10),--($K$2:$K$1179<1000))

I keep getting zero???

Formula Help
 

I just tested your formula and it calculates correctly for me.

Are your data in G:G and K:K formatted as numbers or text?

Dave
--
Brevity is the soul of wit.


"Erika" wrote:

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$11790),--($G$2:$G$1179<10),--($K$2:$K$1179<1000))

I keep getting zero???