Then that would be sumproduct see John Walkenbach's
Count and Sum Your Data in Excel 2002
"Formulas for the Arsenal of Every Excel User
By John Walkenbach, Microsoft Most Valuable Professional (MVP)"
http://www.microsoft.com/office/prev...s/column10.asp

and of course help in Exel

You are more likely to get a specific formula if you take the
time to show a sample of your data (with addresses). But I think, you have sufficient
information to solve your problem. Kind of looks like the general
kind of question one might copy down for a homework assignment.
It is kind of hard to do homework or to ask someone for help unless
you clearly understand the question (definition of problem) and can
clearly ask for help. With a good definition, it is amazing how quickly
one can usually answer their own question, expecially with the help
of Google web search or a Google groups search.
question is understood clearly

--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Raj7" wrote in message ...

sorry, i can't seem to figure out how i can do what i want to do from
that page, maybe i wasnt very clear - sorry

I have four columns in my range and thereofre 4 possible true values.

For each row that has 0 trues in it, i want it to add one to a
table/cell , for each row that has 1 true in it i want it to add one to
a value in the table/cell and so on.

So basically i want it to count how many rows have 0 trues, how many
have 1 true, how many have 2 trues etc. and put this data into a table

Thanks

Raj


--
Raj7
------------------------------------------------------------------------
Raj7's Profile: http://www.excelforum.com/member.php...o&userid=23727
View this thread: http://www.excelforum.com/showthread...hreadid=374004