help.....

[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

 

[DNF Karran]

=SUMIF(F7:F11,"<5",F7:F11)-SUMIF(F7:F11,"<-5",F7:F11)

Is the simplest way.

Dunca

 

[Don Guillett]

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)

 

[Bob Phillips]

=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)