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"

You're going to have to do this in stages.

I think what you want to do is group them by WEEKNUM.
I don't know how you want to group them. Do you want to sum the winnings.
Let's say your dates are in column A1:A20 and your winnings are in column
B1:B20
Create a helper column in C1:C20 with the following formula
C1: =WEEKNUM(A1)
Copy down to C20

I'm doing the rest on the same sheet.

In column E, I have the Sunday Dates. THe first date is in E1.
In F1, put this formula

=SUMIF(B$1:B$20,WEEKNUM(E1),C$1:C$20)

I just realized that the SUMIF formula only gives a positive value. Maybe
someone else can help to fix this.




"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"

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"

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

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

So you can use WEEKNUM in an arrays*?* If so I could'nt get this formula
to work.


=SUMIF(C$1:C$20,WEEKNUM(E1),B$1:B$20)


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

It works for me.

Make sure you have a date in E1 and week numbers in c1:c20.

vane0326 wrote:

So you can use WEEKNUM in an arrays*?* If so I could'nt get this formula
to work.

=SUMIF(C$1:C$20,WEEKNUM(E1),B$1:B$20)

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

--

Dave Peterson