SUMMARY
Conditional Formula: If Worksheet1 cells A1-5 have text, then I want to Sum
Worksheet2 nonadjacent cells. I want results in Worksheet3 cell D4.

I'm trying to create a formula to populate a range of cells, but only if
text exist.

Example: If any cell from A1-A5 has "Yes," then add cells F4, F6, and F8.

Ultimately, I'd actually would like to populate a range of cells with
summation results, if other cells have text ... but for now, a simple formula
would do.

Any experts out there ... please help. Much thanks.