Unfortunately that didn't help much, but I will try to write the if statement according to how you've worded your question. Check
back over the weekend, if you can. I will post my results, if I get to it.

Conan
"kixelsid" <kixelsid.23rbny_1140823803.515@excelforum-nospam.com> wrote in message
news:kixelsid.23rbny_1140823803.515@excelforum-nospam.com...
>
> Thanks for taking a look.
>
> I think if I try to explain what i am trying todo both questions will
> be answered.
>
> On sheet1 I have things set up so each row is an entry. Each colum of
> that row is the number of times something was done. Example: Column A
> is always going to be the date column C will always be and ID number
> and columns E through BD are the diffrent services. A3 = 02/23/06
> C3=991 E3 = 1 AD3 = 5. There may be 1600 rows over a weeks time. I want
> to pull out to another sheet each day by ID number. Where the trobule is
> 991 get 10 entrys on 02/23/06 and I need to total column E through BD.
> Then do the same for 993 on a diffrent sheet.
>
> Hopefully this helps explain things.
>
>
> --
> kixelsid
> ------------------------------------------------------------------------
> kixelsid's Profile: http://www.excelforum.com/member.php...o&userid=31901
> View this thread: http://www.excelforum.com/showthread...hreadid=516301
>