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

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