Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum of cells
Hi
I have data in Cell A1,A2, C1,C2 E1,E2 A C E 10 15 12 1 0 1 I WANT THE SUM OF CELLS A1 & C1 ONLY IF THE VALUE IN A2 AND C2 IS NOT ZERO THIS IS AN EXAMPLE. ACTUALLY THE NUMBER OF CELLS THAT I NEED SUM OF ARE MORE THAN 20 IN THE SHEET. BUT THEY ARE NOT IN ORDER |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum of cells
If the values in your condtional range are always 1 or 0, you could just use
a basic SUMPRODUCT function Do the rest of your values extend across multiple columns, but in rows 1 and 2, or are they always in columns A:E, but down more rows than just 1 and 2? Also, what values can your conditional tests take? -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "ub" wrote: Hi I have data in Cell A1,A2, C1,C2 E1,E2 A C E 10 15 12 1 0 1 I WANT THE SUM OF CELLS A1 & C1 ONLY IF THE VALUE IN A2 AND C2 IS NOT ZERO THIS IS AN EXAMPLE. ACTUALLY THE NUMBER OF CELLS THAT I NEED SUM OF ARE MORE THAN 20 IN THE SHEET. BUT THEY ARE NOT IN ORDER |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Sum of cells | Excel Worksheet Functions | |||
conditional formatting 2 cells | Excel Worksheet Functions | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
Conditional Formatting with two cells | Excel Worksheet Functions | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions |