View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How do I sum multiple days worth of info, into weekly entries.

Yes you are wrong

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"vane0326" wrote in
message ...

Barb Reinhardt Wrote:
Try this formula, I had it backwards
=SUMIF(C$1:C$20,WEEKNUM(E1),B$1:B$20)

"Jspearm" wrote in message
...
I am tracking my poker winnings and have a list of tournaments and

their
dates, payouts, stuff like that. On one worksheet I have information

on
each
tournament. On the next worksheet, I want to include all the

tournaments
from sunday until Sunday and have information on weekly performance.

Ex,
under a title of "week of Feb-19"



I thought tool packs wont work with conjuction with other formula. Am I
wrong*?*


--
vane0326
------------------------------------------------------------------------
vane0326's Profile:
http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=514208