Formula

  • Thread starter Thread starter Glenn Robertson
  • Start date Start date
G

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
 
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
 
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.
 
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
Click to expand...

C2: =COUNTIF(B:B,">=500")-COUNTIF(B:B,">=1000")
or over £1000 but under £25,000
Click to expand...

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