Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get summary of cell range where all cells fullfil a certain vlookup request
Hello,
in column A (A5:A370) are dates from 01-01-2005 to 31-12-2005 in column B (B5:B370) are the week no. for each date, produced by following formula: =ROUNDDOWN(((A7-WEEKDAY(A7,2)-DATE(YEAR(A7+4-WEEKDAY(A7,2)),1,-10))/7),0) where A7 is the 03-01-2005 and the result is 1, for week no.1 in column C (C5:C370) are production figures How can I get the sum of production figures of a certain week. Many thanks for any suggestion Regards, Norbert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range in Offset Help Request | Excel Worksheet Functions | |||
Macro Request: Fill in empty cells with previous Filled cell in column | Excel Worksheet Functions | |||
using vlookup for a range of cells | Excel Worksheet Functions | |||
Use VLookup for range of cells, but with a twist | Excel Worksheet Functions | |||
VLOOKUP - problem in stock request | Excel Worksheet Functions |