Steph,

In next free column, add this formula to B1 and copy down

=IF(B1="CA",C1/SUMPRODUCT(--($A$1:$A$100=A1),--($B$1:$B$100="CA"),$C$1:$C$10
0),"")

form at as percentage

--

HTH

RP

"Steph" wrote in message
...
Hi. I have no idea how to construct this formula. It could be in vb, but
doesn't have to be. Below is a database dump from a timesheet program.
What I need to do is populate the % of Total column as shown below.

For users in states OTHER than CA, we can ignore.
For CA entries, the program creates a total line for me. The data is
always
sorted by user, then by state. So CA data is always lumped together per
user with the ca_total directly below the last CA entry. How can I
formuate
excel to know that jblow has 2 CA entries totaling 98, and the % of the
total for each line is 64% and 36%??

Any help would be greatly appreciated! Thank you!!!

user State Total % of Total
jblow AL 28
jblow CA 63 64%
jblow CA 35 36%
jblow ca_total 98
bdole AK 18
bdole CA 38 53%
bdole CA 34 47%
bdole ca_total 72