help.....

  • Thread starter Thread starter djackson
  • Start date Start date
D

djackson

I am wanting to add the number of cells of a certain range.

Lets say I have range a13:k13, I need it to use the sumif to find th
values <5, and >-5. I assume the sumif would be teh easiest way, bu
cant seem to get the results im looking for. Can anyone throw som
advice this way.

Thanks in advanc
 
1. For the sake of the archives, please use meaningful subject lines such as
Sumif problem
2. try using sumproduct
to count
=SUMPRODUCT((G1:H4>-5)*(G1:H4<5))
to sum
=SUMPRODUCT((G1:H4>-5)*(G1:H4<5)*G1:H4)
 
=SUMPRODUCT((A13:K13>-5)*(A13:K13<5),(A13:K13))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top