Using a Date and corresponding weekday to pull amounts
Hi,
Am Tue, 30 Jul 2013 19:44:24 +0100 schrieb Addatone:
A1 07/22/2013
Monday Tuesday Wednesday Thursday Friday
2132 1539 1317 1712 393
Newest Number 1506 1552 1163 1417 212
1642 1261 1148 1366 190
Oldest Number 1704 1223 1160 1462 258
Total 4852 4036 2308 4245 660
Daily Average 1746 1393.75 1157 1489.25 263.25
the headers of your table are in A2:F2, the daily average in row 10
Then try:
=INDEX(10:10,MATCH(TEXT(A1,"dddd"),A2:F2,0))
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|