Formula

[Glenn Robertson]

I have a formula to look at a Row B (which has a value in
£'s)that will tell me how many in that coloumn are under
£500.00.

C1: Countif(B:B,"<500")

but i need a formula that will tell me how many are over
£500 but under £1000

or over £1000 but under £25,000

 

[Don Guillett]

try
=sumproduct((b2:b200>500)*(b2:b200<1000))

--
Don Guillett
SalesAid Software
(e-mail address removed)
I have a formula to look at a Row B (which has a value in
£'s)that will tell me how many in that coloumn are under
£500.00.

C1: Countif(B:B,"<500")

but i need a formula that will tell me how many are over
£500 but under £1000

or over £1000 but under £25,000

 

[Norman Harker]

Hi Glenn!

Try:
=COUNTIF(B:B,">="&500)-COUNTIF(B:B,">="&1000)
And:
=COUNTIF(B:B,">="&1000)-COUNTIF(B:B,">="&25000)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Jonathan Rynd]

I have a formula to look at a Row B (which has a value in
œ's)that will tell me how many in that coloumn are under
œ500.00.
but i need a formula that will tell me how many are over
£500 but under £1000

C2: =COUNTIF(B:B,">=500")-COUNTIF(B:B,">=1000")

or over £1000 but under £25,000

C3: =COUNTIF(B:B,">=1000")-COUNTIF(B:B,">=25000")