Try this:

=SUMIF(B2:G2,"0",A2:F2)

--
Biff
Microsoft Excel MVP


"Laurie" wrote:

Is there an easy way to post a small example. I have one ready, but it
doesn't look very readable when I paste it.

A B C D E F G H
2 100 a 40 e 3 5
if 2nd cell 0 add cell befor itl to total
if 2nd cell <1 ignore and do not add cell to total
answer row 1 5

"T. Valko" wrote:

How about posting a small example and tell us what result you expect. Also,
tell us where this data is!

--
Biff
Microsoft Excel MVP


"Laurie" wrote:

i have a large spreadsheet where i have to check each 3rd cell to see if it
is greater than 0. if it is, then i have to take the 2nd cell and add it to
others where the cell is greater than 0. If the 3rd cell is 0, then the 2nd
cell is ignored.



Laurie