Validate multiple cells (Not Range) that contain a value, if so, return "Complete"

[raisedwell]

I have a comprehensive checklist that I would like validate if multiple cells contain a value (*) and then provide a status of "Complete" or "Incomplete at the top of the checklist.

(The goal is to ensure that all questions are answered and none were skipped or left blank.)

Scenario #1 (Singe worksheet)
The cells that I need to validate are specific answers and are not in a range of continuous cells (ex. B2, B3, B4, B5) but rather various specific cells (ex. B2, B5, B9, B11, B22).

Scenario #2 (2 Different Worksheets)
Same as above but the cells span across 2 different worksheets. (ex. Sheet1 & Sheet2)

Thanks in advance.

 

[Eric W]

Maybe:

Book1
	A	B	C	D	E
1
2		*		Complete	Complete
3				Complete
4
5		*
6
7
8
9		*
10
11		*
12
13
14
15
16
17
18
19
20
21
22		*
23
Sheet99

Cell Formulas
Range	Formula
E2	E2	=IF((B2="*")+(B5="*")+(B9="*")+(B11="*")+(B22="*")+(Sheet98!C3="*")+(Sheet98!C5="*")=7,"Complete","Incomplete")
D2	D2	=IF(SUMPRODUCT(--(COUNTIF(OFFSET(B1,{1,4,8,10,21},0),"~*")))=5,"Complete","Incomplete")
D3	D3	=IF(AND(SUMPRODUCT(--(COUNTIF(OFFSET(B1,{1,4,8,10,21},0),"~*")))=5,SUMPRODUCT(--(COUNTIF(OFFSET(Sheet98!C1,{2,4},0),"~*")))=2),"Complete","Incomplete")

The D2 formula works well enough if the cells are in a single column. Put the offsets of the desired cells in the array constant (they are 1 less than the row number). For 2 sheets, do 2 of the D2 formulas linked with an AND.

If there is no real pattern that can be exploited, you could just list the cells individually, like in the E2 formula.