| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Query
I have two columns with data, Col N and Col O. If Col O3:O278 has a number =1, I want to take the corresponding value in Col N3:N278 and sum it with all the other cells in Col N that also have a corrsponding value=1 in Col O. So, if O3 has a "1", and O4 has a "1", I want to take the value for N3 and N4 and sum them. -- jimbob ------------------------------------------------------------------------ jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107 View this thread: http://www.excelforum.com/showthread...hreadid=506190 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Query
It sounds like =sumif() should work ok for you:
=sumif(o3:o278,1,n3:n278) jimbob wrote: I have two columns with data, Col N and Col O. If Col O3:O278 has a number =1, I want to take the corresponding value in Col N3:N278 and sum it with all the other cells in Col N that also have a corrsponding value=1 in Col O. So, if O3 has a "1", and O4 has a "1", I want to take the value for N3 and N4 and sum them. -- jimbob ------------------------------------------------------------------------ jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107 View this thread: http://www.excelforum.com/showthread...hreadid=506190 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Query
one way..... =SUMPRODUCT(--(O3:O278=1),N3:N278) Greetings from New Zealand Bill K "jimbob" wrote in message ... I have two columns with data, Col N and Col O. If Col O3:O278 has a number =1, I want to take the corresponding value in Col N3:N278 and sum it with all the other cells in Col N that also have a corrsponding value=1 in Col O. So, if O3 has a "1", and O4 has a "1", I want to take the value for N3 and N4 and sum them. -- jimbob ------------------------------------------------------------------------ jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107 View this thread: http://www.excelforum.com/showthread...hreadid=506190 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Query
Well, I left one little detail out. After I sum the values in N3:N278, I then need to divide that number by the number of times that a value of "1" was found in O3:O278. Thanks so much for your help. -- jimbob ------------------------------------------------------------------------ jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107 View this thread: http://www.excelforum.com/showthread...hreadid=506190 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional MS Query | Excel Worksheet Functions | |||
| Conditional Format Not Working | Excel Discussion (Misc queries) | |||
| AHHH! Again | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| How to preserve conditional formatting on a web query table result | Excel Discussion (Misc queries) | |||
Linear Mode
