If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
help.....
=SUMIF(F7:F11,"5",F7:F11)-SUMIF(F7:F11,"-5",F7:F11)
Is the simplest way. Duncan --- Message posted from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
help.....
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/ |
#4
|
|||
|
|||
help.....
=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/ |
Thread Tools | |
Display Modes | |
|
|