Formula Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erika - 24 Oct 2006 17:32 GMT

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???

Reply to this Message

Dave F - 24 Oct 2006 18:01 GMT

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

Signature

Brevity is the soul of wit.

> 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
[quoted text clipped - 4 lines]
>
> I keep getting zero???

Reply to this Message