I hope you can help-
I am working with 4 columns of data in ROW's 5 thru 27--22 people.
Data is entered or Re/Calcurated (F9) Weekly
COL's are:
E Sucessful Sales Count (whole Number)
- Manual entry
- This Col will be ether a "Blank", or a number >=20. (no "0", or no's 1 thru 19)
I Cumulative Count (number) of weeks for which Data is entered in "COL-E" (CUM Pts)
- "Blank" if no Data ever entered.
- (Whole number-Some weeks there may be NO Data entered in "COL-E" in some "ROW's)
- =IF(E5>10,(I5+E5/10),I5)
J Cumulative Sum of "COL-E" number entries (# Wks)
- "Blank" if no Data ever entered.
- a whole number
- =IF(E5>10,J5+0.1,J5)
K Cumulative AVG of "I/J" (Cum Pts/Wk)
- whole number to a tenth ( 45.6; 1076.3; etc.)
- "Blank" if no Data ever entered
- =IF(J5=0,K5=0,I5/J5)
I need any ROW (I,J,or K) that has no positive Data entry to show "Blank"
- no "0", "#N/A", etc.
All COL's should show "Blank" prior to the first Data entries for the year. ( A Master sheet)
I realize that prior to the start there may be a "DIV/0" problem and I cant seem to get around it.
Hope that someone can help as I am having no success getting what I want-
Thank you--Fred
I am working with 4 columns of data in ROW's 5 thru 27--22 people.
Data is entered or Re/Calcurated (F9) Weekly
COL's are:
E Sucessful Sales Count (whole Number)
- Manual entry
- This Col will be ether a "Blank", or a number >=20. (no "0", or no's 1 thru 19)
I Cumulative Count (number) of weeks for which Data is entered in "COL-E" (CUM Pts)
- "Blank" if no Data ever entered.
- (Whole number-Some weeks there may be NO Data entered in "COL-E" in some "ROW's)
- =IF(E5>10,(I5+E5/10),I5)
J Cumulative Sum of "COL-E" number entries (# Wks)
- "Blank" if no Data ever entered.
- a whole number
- =IF(E5>10,J5+0.1,J5)
K Cumulative AVG of "I/J" (Cum Pts/Wk)
- whole number to a tenth ( 45.6; 1076.3; etc.)
- "Blank" if no Data ever entered
- =IF(J5=0,K5=0,I5/J5)
I need any ROW (I,J,or K) that has no positive Data entry to show "Blank"
- no "0", "#N/A", etc.
All COL's should show "Blank" prior to the first Data entries for the year. ( A Master sheet)
I realize that prior to the start there may be a "DIV/0" problem and I cant seem to get around it.
Hope that someone can help as I am having no success getting what I want-
Thank you--Fred