| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Sumif On Two Columns of Data - How?
Here is the problem in a nutshell:
Column 1 Column 2 58000 100% 7000 50% 7000 50% 50000 50% 50000 50% I need a function that adds all values in column 1 that are 20000 or higher AND are 50% in column 2, lastly I divide the result by two. I tried something like this: =SUMIF(M158:M163, "50%", (L158:L163,"19999")/2 Didn't work. The correct output using the sample numbers above is 50000.00 Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Sumif On Two Columns of Data - How?
Maybe
=SUMPRODUCT((A1:A5=20000)*(B1:B5=50%)*(A1:A5))/2 Mike " wrote: Here is the problem in a nutshell: Column 1 Column 2 58000 100% 7000 50% 7000 50% 50000 50% 50000 50% I need a function that adds all values in column 1 that are 20000 or higher AND are 50% in column 2, lastly I divide the result by two. I tried something like this: =SUMIF(M158:M163, "50%", (L158:L163,"19999")/2 Didn't work. The correct output using the sample numbers above is 50000.00 Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Sumif On Two Columns of Data - How?
On May 9, 4:14*pm, Mike H wrote:
Maybe =SUMPRODUCT((A1:A5=20000)*(B1:B5=50%)*(A1:A5))/2 Mike " wrote: Here is the problem in a nutshell: Column 1 * * Column 2 58000 * * * * * * 100% 7000 * * * * * * * *50% 7000 * * * * * * * *50% 50000 * * * * * * *50% 50000 * * * * * * *50% I need a function that adds all values in column 1 that are 20000 or higher AND are 50% in column 2, lastly I divide the result by two. *I tried something like this: =SUMIF(M158:M163, "50%", (L158:L163,"19999")/2 Didn't work. *The correct output using the sample numbers above is 50000.00 Thanks!- Hide quoted text - - Show quoted text - Thanks Mike! Worked like a charm. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Sumif On Two Columns of Data - How?
Your welcome and thanks for the feedback
" wrote: On May 9, 4:14 pm, Mike H wrote: Maybe =SUMPRODUCT((A1:A5=20000)*(B1:B5=50%)*(A1:A5))/2 Mike " wrote: Here is the problem in a nutshell: Column 1 Column 2 58000 100% 7000 50% 7000 50% 50000 50% 50000 50% I need a function that adds all values in column 1 that are 20000 or higher AND are 50% in column 2, lastly I divide the result by two. I tried something like this: =SUMIF(M158:M163, "50%", (L158:L163,"19999")/2 Didn't work. The correct output using the sample numbers above is 50000.00 Thanks!- Hide quoted text - - Show quoted text - Thanks Mike! Worked like a charm. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif data from multiple columns | Excel Worksheet Functions | |||
| Sumif Multiple Columns | Excel Worksheet Functions | |||
| SUMIF across Columns | Excel Worksheet Functions | |||
| Sumif across columns | Excel Worksheet Functions | |||
| SUMIF testing two columns... | Excel Worksheet Functions | |||
Linear Mode
