If cell begins with x, y, or z |
SUM COUNTIF |

If cell contains |
IF |

If cell equals |
IF |

If cell is blank |
ISBLANK IF |

If cell is greater than |
IF |

If cell is not blank |
ISBLANK IF NOT |

If cell is this OR that |
IF OR |

If cell is x or y and z |
AND IF OR |

If else |
IF |

If NOT this or that |
IF NOT OR |

If this AND that |
AND IF |

Nested IF function example |
IF |