| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing numbers based on 2nd column
Thanks, that worked great. Just what I needed.
"Ron Coderre" wrote: Try this: =SUMIF(B:B,"0",A:A) Does that help? *********** Regards, Ron XL2002, WinXP "John K" wrote: I have a worksheet that has 2 columns A, B. there are numbers in each column. What I want to do is sum only the numbers in column A that have a number greater than 0. ie a1 has 10 and b1 has 1, a2 has 8, b2 has 0 a3 has 7 and b3 has 1. Now I should get 17 when I sum the A column because b2 is 0 so a2 wouldn't be counted. I'm using excel 2002 sp2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Summing rows based on column headings | Excel Worksheet Functions | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Excel countif based on size of numbers in one column in Access | Excel Worksheet Functions | |||
Threaded Mode
