N
Nikhil
I have dates in Col A, text in Col B & Col C.
In Col D will have a count of Col B & Col C ( a range of cells from Col B &
Col C). However i want this count in only that row where the date in Col A
corresponds to Sunday.
Also the count has to be for the entire week i.e. from Monday to Saturday.
e.g. if the date in A1 corresponds to Monday, (A7 will thus be Sunday), then
D7 should give me a count of B1:C7. Similarly D14 should give a count of B8:
C14.
However please note that A1 will not necessarily start from Monday or the
1st of the month. It can be any weekday.
Plz help
Nikhil
In Col D will have a count of Col B & Col C ( a range of cells from Col B &
Col C). However i want this count in only that row where the date in Col A
corresponds to Sunday.
Also the count has to be for the entire week i.e. from Monday to Saturday.
e.g. if the date in A1 corresponds to Monday, (A7 will thus be Sunday), then
D7 should give me a count of B1:C7. Similarly D14 should give a count of B8:
C14.
However please note that A1 will not necessarily start from Monday or the
1st of the month. It can be any weekday.
Plz help
Nikhil