Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumif ?.?
=SUMIF(O25:O55,"= P26",J25:J55) should equal 3 in cell Q26 I'm trying to sum the values in Column J, for the value in column P, which may be located in column O once or multiple times How do I write this formula to use the value of cell P26? The present formula results in a blank cell? If I substitute the value (70) for P26 the results will be correct as there is only one 70 in column O25:O55 and one value of 3 in column J25:J55. If I substitute the value for P27 (80) in the formula, there are two 80's in column O25:O55 and two values ( one of 2 and one of 3 ) in column J25:J55, the results is a fictious number like 3.5. Any help is appreciated. Travelersway -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=389843 |
#2
|
|||
|
|||
I think all you're looking for is =SUMIF(O25:O55,P26,J25:J55) isn't it?
"travelersway" wrote: =SUMIF(O25:O55,"= P26",J25:J55) should equal 3 in cell Q26 I'm trying to sum the values in Column J, for the value in column P, which may be located in column O once or multiple times How do I write this formula to use the value of cell P26? The present formula results in a blank cell? If I substitute the value (70) for P26 the results will be correct as there is only one 70 in column O25:O55 and one value of 3 in column J25:J55. If I substitute the value for P27 (80) in the formula, there are two 80's in column O25:O55 and two values ( one of 2 and one of 3 ) in column J25:J55, the results is a fictious number like 3.5. Any help is appreciated. Travelersway -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=389843 |
#3
|
|||
|
|||
Thank you. That resolves the value for P. I need assistance with this issue. If I substitute the value for P27 (80) in the formula, there are two 80's in column O25:O55 and two values ( one of 2 and one of 3 ) in column J25:J55, the results is a fictious number like 3.5. I don't get (5) ?.? Thanks again, Travelersway -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=389843 |
#4
|
|||
|
|||
I get 5.
-- HTH RP (remove nothere from the email address if mailing direct) "travelersway" wrote in message ... Thank you. That resolves the value for P. I need assistance with this issue. If I substitute the value for P27 (80) in the formula, there are two 80's in column O25:O55 and two values ( one of 2 and one of 3 ) in column J25:J55, the results is a fictious number like 3.5. I don't get (5) ?.? Thanks again, Travelersway -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=389843 |
#5
|
|||
|
|||
Thank you ! It's resolved. Travelersway -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=389843 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
SUMIF Not | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
help with "criterea" in the sumif function | Excel Worksheet Functions |