Still vague to me, I'm afraid, but here's another guess
In C2: =SUMIF(A2:A10,"No",B2:B10)
where A2:A10 would house the "No", "Yes" indications
with B2:B10 containing the corresponding numbers to be summed
Did the above hit the barndoor? wave it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Shevy" wrote:
What i need to tally up is if the NO =
2 in A2
4 in A3
6 in A3
10 in A4
Which would give me a total of 22
and all the YES would = 0