help.....

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 the
values 5, and -5. I assume the sumif would be teh easiest way, but
cant seem to get the results im looking for. Can anyone throw some
advice this way.

Thanks in advance


---
Message posted from http://www.ExcelForum.com/

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

Is the simplest way.

Duncan


---
Message posted from http://www.ExcelForum.com/

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:H45))
to sum
=SUMPRODUCT((G1:H4-5)*(G1:H45)*G1:H4)
--
Don Guillett
SalesAid Software

"djackson " wrote in message
...
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 the
values 5, and -5. I assume the sumif would be teh easiest way, but
cant seem to get the results im looking for. Can anyone throw some
advice this way.

Thanks in advance


---
Message posted from http://www.ExcelForum.com/

=SUMPRODUCT((A13:K13-5)*(A13:K135),(A13:K13))

--

HTH

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

"djackson " wrote in message
...
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 the
values 5, and -5. I assume the sumif would be teh easiest way, but
cant seem to get the results im looking for. Can anyone throw some
advice this way.

Thanks in advance


---
Message posted from http://www.ExcelForum.com/