New: ready-to-use spreadsheet templatesExplore the collection  →
SheetSteps
Fix my formula →
GOOGLE SHEETS FORMULA RECIPES

Start with what you need
the sheet to do.

Paste-ready formulas for everyday spreadsheet jobs, each paired with editable data and tested variations.

01 · Conditions

If cell contains text

Return a label when a cell contains a word or phrase, including partial matches.

=IF(REGEXMATCH(A2,"paid"),"Complete","Open")Open recipe →02 · Conditions

Leave result blank

Keep a formula cell empty until its source cell has data.

=IF(A2="","",B2*C2)Open recipe →03 · Counting & sums

Count unique with criteria

Count distinct entries after limiting rows to a chosen status or group.

=COUNTUNIQUE(FILTER(A2:A,B2:B="Paid"))Open recipe →04 · Counting & sums

Sum between two dates

Add amounts whose dates fall inside a start and end date.

=SUMIFS(B2:B,A2:A,">="&E2,A2:A,"<="&F2)Open recipe →05 · Counting & sums

Sum multiple sheets

Add the same cell or range from several worksheet tabs.

=SUM(January!B2,February!B2,March!B2)Open recipe →06 · Filtering & lookup

FILTER with multiple conditions

Return rows that meet two or more conditions at the same time.

=FILTER(A2:C,B2:B="West",C2:C>=1000)Open recipe →07 · Filtering & lookup

FILTER using OR

Return rows when either of two or more conditions is true.

=FILTER(A2:C,(B2:B="West")+(B2:B="East"))Open recipe →08 · Filtering & lookup

Last non-empty value

Find the most recent filled value in a column while ignoring blanks.

=LOOKUP(2,1/(A2:A<>""),A2:A)Open recipe →09 · Filtering & lookup

Lookup from another sheet

Match an ID on one tab and return a field from another tab.

=XLOOKUP(A2,Products!A:A,Products!C:C,"Not found")Open recipe →10 · Filtering & lookup

Reverse VLOOKUP

Look to the left of the match column by using XLOOKUP or INDEX MATCH.

=XLOOKUP(E2,C2:C,A2:A,"Not found")Open recipe →11 · Filtering & lookup

Case-sensitive lookup

Match IDs that differ only by uppercase and lowercase letters.

=INDEX(B2:B,MATCH(TRUE,EXACT(E2,A2:A),0))Open recipe →12 · Text

Extract an email address

Pull the first email address out of a sentence, note or imported text block.

=IFERROR(REGEXEXTRACT(A2,"[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}"),"")Open recipe →13 · Text

Extract a URL domain

Turn a full URL into a clean hostname without the protocol, path or query string.

=REGEXEXTRACT(A2,"^(?:https?://)?(?:www\.)?([^/]+)")Open recipe →14 · Text

Remove first or last characters

Trim a fixed number of characters from the beginning or end of text.

=RIGHT(A2,LEN(A2)-3)Open recipe →15 · Rows & arrays

Calculate a running total

Keep a cumulative sum that grows as new values are added.

=SUM($B$2:B2)Open recipe →16 · Rows & arrays

Number rows automatically

Generate row numbers only when the row contains data.

=ARRAYFORMULA(IF(B2:B="","",ROW(B2:B)-ROW(B2)+1))Open recipe →17 · Rows & arrays

Combine multiple columns

Join names, labels or address parts while skipping empty cells.

=TEXTJOIN(" ",TRUE,A2:C2)Open recipe →18 · Rows & arrays

Duplicates across two columns

Mark values in one list that also appear in another list.

=IF(COUNTIF($B$2:$B,A2)>0,"Duplicate","")Open recipe →19 · Formatting

Formatting from another cell

Apply a format to one cell by testing the value in another column.

=$C2="Overdue"Open recipe →20 · Formatting

Highlight row by status

Color every cell in a row when its status column contains a chosen label.

=$D2="Complete"Open recipe →21 · Counting & sums

Count completed invoice rows

Count invoice rows whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →22 · Counting & sums

Count open invoice rows

Count invoice rows that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →23 · Counting & sums

Count invoice rows by region

Count invoice rows assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →24 · Counting & sums

Count invoice rows containing text

Count invoice rows whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →25 · Counting & sums

Count non-empty invoice rows

Count filled invoice cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →26 · Counting & sums

Count blank invoice row notes

Find how many invoice rows have no note entered.

=COUNTBLANK(F2:F)Open recipe →27 · Counting & sums

Count invoice rows over 1000

Count invoice rows whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →28 · Counting & sums

Count invoice rows between amounts

Count invoice rows with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →29 · Counting & sums

Count invoice rows between dates

Count invoice rows dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →30 · Counting & sums

Count unique completed invoice rows

Count distinct invoice labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →31 · Counting & sums

Sum completed invoice rows

Add Amount values only for invoice rows marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →32 · Counting & sums

Sum invoice rows by region

Add Amount values for invoice rows assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →33 · Counting & sums

Sum invoice rows between dates

Add Amount values for invoice rows dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →34 · Counting & sums

Sum invoice rows containing text

Add Amount values when the invoice row note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →35 · Counting & sums

Average completed invoice rows

Calculate the average Amount for invoice rows marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →36 · Counting & sums

Average invoice rows without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →37 · Filtering & lookup

Filter completed invoice rows

Return every invoice row row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →38 · Filtering & lookup

Filter invoice rows with AND

Return invoice rows that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →39 · Filtering & lookup

Filter invoice rows with OR

Return invoice rows whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →40 · Filtering & lookup

Filter invoice rows containing text

Return invoice rows whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →41 · Filtering & lookup

Lookup a invoice row amount

Match a invoice label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →42 · Filtering & lookup

Last completed invoice row

Return the final invoice label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →43 · Conditions

Label completed invoice rows

Return Done for a Complete invoice row; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →44 · Conditions

Leave blank invoice row results blank

Keep the result empty when the invoice cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →45 · Rows & arrays

Invoice running total

Create a cumulative Amount total that grows down the invoice rows table.

=SUM($C$2:C2)Open recipe →46 · Counting & sums

Count completed orders

Count orders whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →47 · Counting & sums

Count open orders

Count orders that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →48 · Counting & sums

Count orders by region

Count orders assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →49 · Counting & sums

Count orders containing text

Count orders whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →50 · Counting & sums

Count non-empty orders

Count filled order cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →51 · Counting & sums

Count blank order notes

Find how many orders have no note entered.

=COUNTBLANK(F2:F)Open recipe →52 · Counting & sums

Count orders over 1000

Count orders whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →53 · Counting & sums

Count orders between amounts

Count orders with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →54 · Counting & sums

Count orders between dates

Count orders dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →55 · Counting & sums

Count unique completed orders

Count distinct order labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →56 · Counting & sums

Sum completed orders

Add Amount values only for orders marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →57 · Counting & sums

Sum orders by region

Add Amount values for orders assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →58 · Counting & sums

Sum orders between dates

Add Amount values for orders dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →59 · Counting & sums

Sum orders containing text

Add Amount values when the order note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →60 · Counting & sums

Average completed orders

Calculate the average Amount for orders marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →61 · Counting & sums

Average orders without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →62 · Filtering & lookup

Filter completed orders

Return every order row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →63 · Filtering & lookup

Filter orders with AND

Return orders that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →64 · Filtering & lookup

Filter orders with OR

Return orders whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →65 · Filtering & lookup

Filter orders containing text

Return orders whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →66 · Filtering & lookup

Lookup a order amount

Match a order label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →67 · Filtering & lookup

Last completed order

Return the final order label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →68 · Conditions

Label completed orders

Return Done for a Complete order; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →69 · Conditions

Leave blank order results blank

Keep the result empty when the order cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →70 · Rows & arrays

Order running total

Create a cumulative Amount total that grows down the orders table.

=SUM($C$2:C2)Open recipe →71 · Counting & sums

Count completed expenses

Count expenses whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →72 · Counting & sums

Count open expenses

Count expenses that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →73 · Counting & sums

Count expenses by region

Count expenses assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →74 · Counting & sums

Count expenses containing text

Count expenses whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →75 · Counting & sums

Count non-empty expenses

Count filled expense cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →76 · Counting & sums

Count blank expense notes

Find how many expenses have no note entered.

=COUNTBLANK(F2:F)Open recipe →77 · Counting & sums

Count expenses over 1000

Count expenses whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →78 · Counting & sums

Count expenses between amounts

Count expenses with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →79 · Counting & sums

Count expenses between dates

Count expenses dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →80 · Counting & sums

Count unique completed expenses

Count distinct expense labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →81 · Counting & sums

Sum completed expenses

Add Amount values only for expenses marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →82 · Counting & sums

Sum expenses by region

Add Amount values for expenses assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →83 · Counting & sums

Sum expenses between dates

Add Amount values for expenses dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →84 · Counting & sums

Sum expenses containing text

Add Amount values when the expense note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →85 · Counting & sums

Average completed expenses

Calculate the average Amount for expenses marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →86 · Counting & sums

Average expenses without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →87 · Filtering & lookup

Filter completed expenses

Return every expense row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →88 · Filtering & lookup

Filter expenses with AND

Return expenses that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →89 · Filtering & lookup

Filter expenses with OR

Return expenses whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →90 · Filtering & lookup

Filter expenses containing text

Return expenses whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →91 · Filtering & lookup

Lookup a expense amount

Match a expense label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →92 · Filtering & lookup

Last completed expense

Return the final expense label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →93 · Conditions

Label completed expenses

Return Done for a Complete expense; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →94 · Conditions

Leave blank expense results blank

Keep the result empty when the expense cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →95 · Rows & arrays

Expense running total

Create a cumulative Amount total that grows down the expenses table.

=SUM($C$2:C2)Open recipe →96 · Counting & sums

Count completed tasks

Count tasks whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →97 · Counting & sums

Count open tasks

Count tasks that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →98 · Counting & sums

Count tasks by region

Count tasks assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →99 · Counting & sums

Count tasks containing text

Count tasks whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →100 · Counting & sums

Count non-empty tasks

Count filled task cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →101 · Counting & sums

Count blank task notes

Find how many tasks have no note entered.

=COUNTBLANK(F2:F)Open recipe →102 · Counting & sums

Count tasks over 1000

Count tasks whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →103 · Counting & sums

Count tasks between amounts

Count tasks with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →104 · Counting & sums

Count tasks between dates

Count tasks dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →105 · Counting & sums

Count unique completed tasks

Count distinct task labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →106 · Counting & sums

Sum completed tasks

Add Amount values only for tasks marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →107 · Counting & sums

Sum tasks by region

Add Amount values for tasks assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →108 · Counting & sums

Sum tasks between dates

Add Amount values for tasks dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →109 · Counting & sums

Sum tasks containing text

Add Amount values when the task note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →110 · Counting & sums

Average completed tasks

Calculate the average Amount for tasks marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →111 · Counting & sums

Average tasks without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →112 · Filtering & lookup

Filter completed tasks

Return every task row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →113 · Filtering & lookup

Filter tasks with AND

Return tasks that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →114 · Filtering & lookup

Filter tasks with OR

Return tasks whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →115 · Filtering & lookup

Filter tasks containing text

Return tasks whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →116 · Filtering & lookup

Lookup a task amount

Match a task label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →117 · Filtering & lookup

Last completed task

Return the final task label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →118 · Conditions

Label completed tasks

Return Done for a Complete task; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →119 · Conditions

Leave blank task results blank

Keep the result empty when the task cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →120 · Rows & arrays

Task running total

Create a cumulative Amount total that grows down the tasks table.

=SUM($C$2:C2)Open recipe →121 · Counting & sums

Count completed projects

Count projects whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →122 · Counting & sums

Count open projects

Count projects that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →123 · Counting & sums

Count projects by region

Count projects assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →124 · Counting & sums

Count projects containing text

Count projects whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →125 · Counting & sums

Count non-empty projects

Count filled project cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →126 · Counting & sums

Count blank project notes

Find how many projects have no note entered.

=COUNTBLANK(F2:F)Open recipe →127 · Counting & sums

Count projects over 1000

Count projects whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →128 · Counting & sums

Count projects between amounts

Count projects with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →129 · Counting & sums

Count projects between dates

Count projects dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →130 · Counting & sums

Count unique completed projects

Count distinct project labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →131 · Counting & sums

Sum completed projects

Add Amount values only for projects marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →132 · Counting & sums

Sum projects by region

Add Amount values for projects assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →133 · Counting & sums

Sum projects between dates

Add Amount values for projects dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →134 · Counting & sums

Sum projects containing text

Add Amount values when the project note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →135 · Counting & sums

Average completed projects

Calculate the average Amount for projects marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →136 · Counting & sums

Average projects without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →137 · Filtering & lookup

Filter completed projects

Return every project row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →138 · Filtering & lookup

Filter projects with AND

Return projects that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →139 · Filtering & lookup

Filter projects with OR

Return projects whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →140 · Filtering & lookup

Filter projects containing text

Return projects whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →141 · Filtering & lookup

Lookup a project amount

Match a project label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →142 · Filtering & lookup

Last completed project

Return the final project label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →143 · Conditions

Label completed projects

Return Done for a Complete project; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →144 · Conditions

Leave blank project results blank

Keep the result empty when the project cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →145 · Rows & arrays

Project running total

Create a cumulative Amount total that grows down the projects table.

=SUM($C$2:C2)Open recipe →146 · Counting & sums

Count completed customers

Count customers whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →147 · Counting & sums

Count open customers

Count customers that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →148 · Counting & sums

Count customers by region

Count customers assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →149 · Counting & sums

Count customers containing text

Count customers whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →150 · Counting & sums

Count non-empty customers

Count filled customer cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →151 · Counting & sums

Count blank customer notes

Find how many customers have no note entered.

=COUNTBLANK(F2:F)Open recipe →152 · Counting & sums

Count customers over 1000

Count customers whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →153 · Counting & sums

Count customers between amounts

Count customers with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →154 · Counting & sums

Count customers between dates

Count customers dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →155 · Counting & sums

Count unique completed customers

Count distinct customer labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →156 · Counting & sums

Sum completed customers

Add Amount values only for customers marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →157 · Counting & sums

Sum customers by region

Add Amount values for customers assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →158 · Counting & sums

Sum customers between dates

Add Amount values for customers dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →159 · Counting & sums

Sum customers containing text

Add Amount values when the customer note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →160 · Counting & sums

Average completed customers

Calculate the average Amount for customers marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →161 · Counting & sums

Average customers without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →162 · Filtering & lookup

Filter completed customers

Return every customer row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →163 · Filtering & lookup

Filter customers with AND

Return customers that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →164 · Filtering & lookup

Filter customers with OR

Return customers whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →165 · Filtering & lookup

Filter customers containing text

Return customers whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →166 · Filtering & lookup

Lookup a customer amount

Match a customer label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →167 · Filtering & lookup

Last completed customer

Return the final customer label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →168 · Conditions

Label completed customers

Return Done for a Complete customer; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →169 · Conditions

Leave blank customer results blank

Keep the result empty when the customer cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →170 · Rows & arrays

Customer running total

Create a cumulative Amount total that grows down the customers table.

=SUM($C$2:C2)Open recipe →171 · Counting & sums

Count completed leads

Count leads whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →172 · Counting & sums

Count open leads

Count leads that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →173 · Counting & sums

Count leads by region

Count leads assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →174 · Counting & sums

Count leads containing text

Count leads whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →175 · Counting & sums

Count non-empty leads

Count filled lead cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →176 · Counting & sums

Count blank lead notes

Find how many leads have no note entered.

=COUNTBLANK(F2:F)Open recipe →177 · Counting & sums

Count leads over 1000

Count leads whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →178 · Counting & sums

Count leads between amounts

Count leads with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →179 · Counting & sums

Count leads between dates

Count leads dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →180 · Counting & sums

Count unique completed leads

Count distinct lead labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →181 · Counting & sums

Sum completed leads

Add Amount values only for leads marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →182 · Counting & sums

Sum leads by region

Add Amount values for leads assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →183 · Counting & sums

Sum leads between dates

Add Amount values for leads dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →184 · Counting & sums

Sum leads containing text

Add Amount values when the lead note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →185 · Counting & sums

Average completed leads

Calculate the average Amount for leads marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →186 · Counting & sums

Average leads without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →187 · Filtering & lookup

Filter completed leads

Return every lead row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →188 · Filtering & lookup

Filter leads with AND

Return leads that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →189 · Filtering & lookup

Filter leads with OR

Return leads whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →190 · Filtering & lookup

Filter leads containing text

Return leads whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →191 · Filtering & lookup

Lookup a lead amount

Match a lead label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →192 · Filtering & lookup

Last completed lead

Return the final lead label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →193 · Conditions

Label completed leads

Return Done for a Complete lead; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →194 · Conditions

Leave blank lead results blank

Keep the result empty when the lead cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →195 · Rows & arrays

Lead running total

Create a cumulative Amount total that grows down the leads table.

=SUM($C$2:C2)Open recipe →196 · Counting & sums

Count completed deals

Count deals whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →197 · Counting & sums

Count open deals

Count deals that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →198 · Counting & sums

Count deals by region

Count deals assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →199 · Counting & sums

Count deals containing text

Count deals whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →200 · Counting & sums

Count non-empty deals

Count filled deal cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →201 · Counting & sums

Count blank deal notes

Find how many deals have no note entered.

=COUNTBLANK(F2:F)Open recipe →202 · Counting & sums

Count deals over 1000

Count deals whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →203 · Counting & sums

Count deals between amounts

Count deals with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →204 · Counting & sums

Count deals between dates

Count deals dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →205 · Counting & sums

Count unique completed deals

Count distinct deal labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →206 · Counting & sums

Sum completed deals

Add Amount values only for deals marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →207 · Counting & sums

Sum deals by region

Add Amount values for deals assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →208 · Counting & sums

Sum deals between dates

Add Amount values for deals dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →209 · Counting & sums

Sum deals containing text

Add Amount values when the deal note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →210 · Counting & sums

Average completed deals

Calculate the average Amount for deals marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →211 · Counting & sums

Average deals without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →212 · Filtering & lookup

Filter completed deals

Return every deal row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →213 · Filtering & lookup

Filter deals with AND

Return deals that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →214 · Filtering & lookup

Filter deals with OR

Return deals whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →215 · Filtering & lookup

Filter deals containing text

Return deals whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →216 · Filtering & lookup

Lookup a deal amount

Match a deal label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →217 · Filtering & lookup

Last completed deal

Return the final deal label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →218 · Conditions

Label completed deals

Return Done for a Complete deal; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →219 · Conditions

Leave blank deal results blank

Keep the result empty when the deal cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →220 · Rows & arrays

Deal running total

Create a cumulative Amount total that grows down the deals table.

=SUM($C$2:C2)Open recipe →221 · Counting & sums

Count completed products

Count products whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →222 · Counting & sums

Count open products

Count products that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →223 · Counting & sums

Count products by region

Count products assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →224 · Counting & sums

Count products containing text

Count products whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →225 · Counting & sums

Count non-empty products

Count filled product cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →226 · Counting & sums

Count blank product notes

Find how many products have no note entered.

=COUNTBLANK(F2:F)Open recipe →227 · Counting & sums

Count products over 1000

Count products whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →228 · Counting & sums

Count products between amounts

Count products with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →229 · Counting & sums

Count products between dates

Count products dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →230 · Counting & sums

Count unique completed products

Count distinct product labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →231 · Counting & sums

Sum completed products

Add Amount values only for products marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →232 · Counting & sums

Sum products by region

Add Amount values for products assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →233 · Counting & sums

Sum products between dates

Add Amount values for products dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →234 · Counting & sums

Sum products containing text

Add Amount values when the product note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →235 · Counting & sums

Average completed products

Calculate the average Amount for products marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →236 · Counting & sums

Average products without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →237 · Filtering & lookup

Filter completed products

Return every product row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →238 · Filtering & lookup

Filter products with AND

Return products that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →239 · Filtering & lookup

Filter products with OR

Return products whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →240 · Filtering & lookup

Filter products containing text

Return products whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →241 · Filtering & lookup

Lookup a product amount

Match a product label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →242 · Filtering & lookup

Last completed product

Return the final product label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →243 · Conditions

Label completed products

Return Done for a Complete product; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →244 · Conditions

Leave blank product results blank

Keep the result empty when the product cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →245 · Rows & arrays

Product running total

Create a cumulative Amount total that grows down the products table.

=SUM($C$2:C2)Open recipe →246 · Counting & sums

Count completed inventory items

Count inventory items whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →247 · Counting & sums

Count open inventory items

Count inventory items that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →248 · Counting & sums

Count inventory items by region

Count inventory items assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →249 · Counting & sums

Count inventory items containing text

Count inventory items whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →250 · Counting & sums

Count non-empty inventory items

Count filled item cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →251 · Counting & sums

Count blank inventory item notes

Find how many inventory items have no note entered.

=COUNTBLANK(F2:F)Open recipe →252 · Counting & sums

Count inventory items over 1000

Count inventory items whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →253 · Counting & sums

Count inventory items between amounts

Count inventory items with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →254 · Counting & sums

Count inventory items between dates

Count inventory items dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →255 · Counting & sums

Count unique completed inventory items

Count distinct item labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →256 · Counting & sums

Sum completed inventory items

Add Amount values only for inventory items marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →257 · Counting & sums

Sum inventory items by region

Add Amount values for inventory items assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →258 · Counting & sums

Sum inventory items between dates

Add Amount values for inventory items dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →259 · Counting & sums

Sum inventory items containing text

Add Amount values when the inventory item note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →260 · Counting & sums

Average completed inventory items

Calculate the average Amount for inventory items marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →261 · Counting & sums

Average inventory items without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →262 · Filtering & lookup

Filter completed inventory items

Return every inventory item row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →263 · Filtering & lookup

Filter inventory items with AND

Return inventory items that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →264 · Filtering & lookup

Filter inventory items with OR

Return inventory items whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →265 · Filtering & lookup

Filter inventory items containing text

Return inventory items whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →266 · Filtering & lookup

Lookup a inventory item amount

Match a item label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →267 · Filtering & lookup

Last completed inventory item

Return the final item label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →268 · Conditions

Label completed inventory items

Return Done for a Complete inventory item; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →269 · Conditions

Leave blank inventory item results blank

Keep the result empty when the item cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →270 · Rows & arrays

Item running total

Create a cumulative Amount total that grows down the inventory items table.

=SUM($C$2:C2)Open recipe →271 · Counting & sums

Count completed shipments

Count shipments whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →272 · Counting & sums

Count open shipments

Count shipments that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →273 · Counting & sums

Count shipments by region

Count shipments assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →274 · Counting & sums

Count shipments containing text

Count shipments whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →275 · Counting & sums

Count non-empty shipments

Count filled shipment cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →276 · Counting & sums

Count blank shipment notes

Find how many shipments have no note entered.

=COUNTBLANK(F2:F)Open recipe →277 · Counting & sums

Count shipments over 1000

Count shipments whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →278 · Counting & sums

Count shipments between amounts

Count shipments with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →279 · Counting & sums

Count shipments between dates

Count shipments dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →280 · Counting & sums

Count unique completed shipments

Count distinct shipment labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →281 · Counting & sums

Sum completed shipments

Add Amount values only for shipments marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →282 · Counting & sums

Sum shipments by region

Add Amount values for shipments assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →283 · Counting & sums

Sum shipments between dates

Add Amount values for shipments dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →284 · Counting & sums

Sum shipments containing text

Add Amount values when the shipment note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →285 · Counting & sums

Average completed shipments

Calculate the average Amount for shipments marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →286 · Counting & sums

Average shipments without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →287 · Filtering & lookup

Filter completed shipments

Return every shipment row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →288 · Filtering & lookup

Filter shipments with AND

Return shipments that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →289 · Filtering & lookup

Filter shipments with OR

Return shipments whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →290 · Filtering & lookup

Filter shipments containing text

Return shipments whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →291 · Filtering & lookup

Lookup a shipment amount

Match a shipment label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →292 · Filtering & lookup

Last completed shipment

Return the final shipment label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →293 · Conditions

Label completed shipments

Return Done for a Complete shipment; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →294 · Conditions

Leave blank shipment results blank

Keep the result empty when the shipment cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →295 · Rows & arrays

Shipment running total

Create a cumulative Amount total that grows down the shipments table.

=SUM($C$2:C2)Open recipe →296 · Counting & sums

Count completed support tickets

Count support tickets whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →297 · Counting & sums

Count open support tickets

Count support tickets that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →298 · Counting & sums

Count support tickets by region

Count support tickets assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →299 · Counting & sums

Count support tickets containing text

Count support tickets whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →300 · Counting & sums

Count non-empty support tickets

Count filled ticket cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →301 · Counting & sums

Count blank support ticket notes

Find how many support tickets have no note entered.

=COUNTBLANK(F2:F)Open recipe →302 · Counting & sums

Count support tickets over 1000

Count support tickets whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →303 · Counting & sums

Count support tickets between amounts

Count support tickets with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →304 · Counting & sums

Count support tickets between dates

Count support tickets dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →305 · Counting & sums

Count unique completed support tickets

Count distinct ticket labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →306 · Counting & sums

Sum completed support tickets

Add Amount values only for support tickets marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →307 · Counting & sums

Sum support tickets by region

Add Amount values for support tickets assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →308 · Counting & sums

Sum support tickets between dates

Add Amount values for support tickets dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →309 · Counting & sums

Sum support tickets containing text

Add Amount values when the support ticket note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →310 · Counting & sums

Average completed support tickets

Calculate the average Amount for support tickets marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →311 · Counting & sums

Average support tickets without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →312 · Filtering & lookup

Filter completed support tickets

Return every support ticket row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →313 · Filtering & lookup

Filter support tickets with AND

Return support tickets that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →314 · Filtering & lookup

Filter support tickets with OR

Return support tickets whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →315 · Filtering & lookup

Filter support tickets containing text

Return support tickets whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →316 · Filtering & lookup

Lookup a support ticket amount

Match a ticket label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →317 · Filtering & lookup

Last completed support ticket

Return the final ticket label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →318 · Conditions

Label completed support tickets

Return Done for a Complete support ticket; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →319 · Conditions

Leave blank support ticket results blank

Keep the result empty when the ticket cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →320 · Rows & arrays

Ticket running total

Create a cumulative Amount total that grows down the support tickets table.

=SUM($C$2:C2)Open recipe →321 · Counting & sums

Count completed employees

Count employees whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →322 · Counting & sums

Count open employees

Count employees that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →323 · Counting & sums

Count employees by region

Count employees assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →324 · Counting & sums

Count employees containing text

Count employees whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →325 · Counting & sums

Count non-empty employees

Count filled employee cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →326 · Counting & sums

Count blank employee notes

Find how many employees have no note entered.

=COUNTBLANK(F2:F)Open recipe →327 · Counting & sums

Count employees over 1000

Count employees whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →328 · Counting & sums

Count employees between amounts

Count employees with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →329 · Counting & sums

Count employees between dates

Count employees dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →330 · Counting & sums

Count unique completed employees

Count distinct employee labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →331 · Counting & sums

Sum completed employees

Add Amount values only for employees marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →332 · Counting & sums

Sum employees by region

Add Amount values for employees assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →333 · Counting & sums

Sum employees between dates

Add Amount values for employees dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →334 · Counting & sums

Sum employees containing text

Add Amount values when the employee note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →335 · Counting & sums

Average completed employees

Calculate the average Amount for employees marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →336 · Counting & sums

Average employees without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →337 · Filtering & lookup

Filter completed employees

Return every employee row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →338 · Filtering & lookup

Filter employees with AND

Return employees that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →339 · Filtering & lookup

Filter employees with OR

Return employees whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →340 · Filtering & lookup

Filter employees containing text

Return employees whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →341 · Filtering & lookup

Lookup a employee amount

Match a employee label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →342 · Filtering & lookup

Last completed employee

Return the final employee label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →343 · Conditions

Label completed employees

Return Done for a Complete employee; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →344 · Conditions

Leave blank employee results blank

Keep the result empty when the employee cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →345 · Rows & arrays

Employee running total

Create a cumulative Amount total that grows down the employees table.

=SUM($C$2:C2)Open recipe →346 · Counting & sums

Count completed applicants

Count applicants whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →347 · Counting & sums

Count open applicants

Count applicants that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →348 · Counting & sums

Count applicants by region

Count applicants assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →349 · Counting & sums

Count applicants containing text

Count applicants whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →350 · Counting & sums

Count non-empty applicants

Count filled applicant cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →351 · Counting & sums

Count blank applicant notes

Find how many applicants have no note entered.

=COUNTBLANK(F2:F)Open recipe →352 · Counting & sums

Count applicants over 1000

Count applicants whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →353 · Counting & sums

Count applicants between amounts

Count applicants with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →354 · Counting & sums

Count applicants between dates

Count applicants dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →355 · Counting & sums

Count unique completed applicants

Count distinct applicant labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →356 · Counting & sums

Sum completed applicants

Add Amount values only for applicants marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →357 · Counting & sums

Sum applicants by region

Add Amount values for applicants assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →358 · Counting & sums

Sum applicants between dates

Add Amount values for applicants dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →359 · Counting & sums

Sum applicants containing text

Add Amount values when the applicant note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →360 · Counting & sums

Average completed applicants

Calculate the average Amount for applicants marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →361 · Counting & sums

Average applicants without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →362 · Filtering & lookup

Filter completed applicants

Return every applicant row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →363 · Filtering & lookup

Filter applicants with AND

Return applicants that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →364 · Filtering & lookup

Filter applicants with OR

Return applicants whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →365 · Filtering & lookup

Filter applicants containing text

Return applicants whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →366 · Filtering & lookup

Lookup a applicant amount

Match a applicant label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →367 · Filtering & lookup

Last completed applicant

Return the final applicant label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →368 · Conditions

Label completed applicants

Return Done for a Complete applicant; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →369 · Conditions

Leave blank applicant results blank

Keep the result empty when the applicant cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →370 · Rows & arrays

Applicant running total

Create a cumulative Amount total that grows down the applicants table.

=SUM($C$2:C2)Open recipe →371 · Counting & sums

Count completed students

Count students whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →372 · Counting & sums

Count open students

Count students that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →373 · Counting & sums

Count students by region

Count students assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →374 · Counting & sums

Count students containing text

Count students whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →375 · Counting & sums

Count non-empty students

Count filled student cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →376 · Counting & sums

Count blank student notes

Find how many students have no note entered.

=COUNTBLANK(F2:F)Open recipe →377 · Counting & sums

Count students over 1000

Count students whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →378 · Counting & sums

Count students between amounts

Count students with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →379 · Counting & sums

Count students between dates

Count students dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →380 · Counting & sums

Count unique completed students

Count distinct student labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →381 · Counting & sums

Sum completed students

Add Amount values only for students marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →382 · Counting & sums

Sum students by region

Add Amount values for students assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →383 · Counting & sums

Sum students between dates

Add Amount values for students dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →384 · Counting & sums

Sum students containing text

Add Amount values when the student note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →385 · Counting & sums

Average completed students

Calculate the average Amount for students marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →386 · Counting & sums

Average students without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →387 · Filtering & lookup

Filter completed students

Return every student row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →388 · Filtering & lookup

Filter students with AND

Return students that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →389 · Filtering & lookup

Filter students with OR

Return students whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →390 · Filtering & lookup

Filter students containing text

Return students whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →391 · Filtering & lookup

Lookup a student amount

Match a student label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →392 · Filtering & lookup

Last completed student

Return the final student label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →393 · Conditions

Label completed students

Return Done for a Complete student; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →394 · Conditions

Leave blank student results blank

Keep the result empty when the student cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →395 · Rows & arrays

Student running total

Create a cumulative Amount total that grows down the students table.

=SUM($C$2:C2)Open recipe →396 · Counting & sums

Count completed assignments

Count assignments whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →397 · Counting & sums

Count open assignments

Count assignments that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →398 · Counting & sums

Count assignments by region

Count assignments assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →399 · Counting & sums

Count assignments containing text

Count assignments whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →400 · Counting & sums

Count non-empty assignments

Count filled assignment cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →401 · Counting & sums

Count blank assignment notes

Find how many assignments have no note entered.

=COUNTBLANK(F2:F)Open recipe →402 · Counting & sums

Count assignments over 1000

Count assignments whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →403 · Counting & sums

Count assignments between amounts

Count assignments with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →404 · Counting & sums

Count assignments between dates

Count assignments dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →405 · Counting & sums

Count unique completed assignments

Count distinct assignment labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →406 · Counting & sums

Sum completed assignments

Add Amount values only for assignments marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →407 · Counting & sums

Sum assignments by region

Add Amount values for assignments assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →408 · Counting & sums

Sum assignments between dates

Add Amount values for assignments dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →409 · Counting & sums

Sum assignments containing text

Add Amount values when the assignment note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →410 · Counting & sums

Average completed assignments

Calculate the average Amount for assignments marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →411 · Counting & sums

Average assignments without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →412 · Filtering & lookup

Filter completed assignments

Return every assignment row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →413 · Filtering & lookup

Filter assignments with AND

Return assignments that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →414 · Filtering & lookup

Filter assignments with OR

Return assignments whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →415 · Filtering & lookup

Filter assignments containing text

Return assignments whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →416 · Filtering & lookup

Lookup a assignment amount

Match a assignment label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →417 · Filtering & lookup

Last completed assignment

Return the final assignment label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →418 · Conditions

Label completed assignments

Return Done for a Complete assignment; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →419 · Conditions

Leave blank assignment results blank

Keep the result empty when the assignment cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →420 · Rows & arrays

Assignment running total

Create a cumulative Amount total that grows down the assignments table.

=SUM($C$2:C2)Open recipe →421 · Counting & sums

Count completed courses

Count courses whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →422 · Counting & sums

Count open courses

Count courses that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →423 · Counting & sums

Count courses by region

Count courses assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →424 · Counting & sums

Count courses containing text

Count courses whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →425 · Counting & sums

Count non-empty courses

Count filled course cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →426 · Counting & sums

Count blank course notes

Find how many courses have no note entered.

=COUNTBLANK(F2:F)Open recipe →427 · Counting & sums

Count courses over 1000

Count courses whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →428 · Counting & sums

Count courses between amounts

Count courses with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →429 · Counting & sums

Count courses between dates

Count courses dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →430 · Counting & sums

Count unique completed courses

Count distinct course labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →431 · Counting & sums

Sum completed courses

Add Amount values only for courses marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →432 · Counting & sums

Sum courses by region

Add Amount values for courses assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →433 · Counting & sums

Sum courses between dates

Add Amount values for courses dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →434 · Counting & sums

Sum courses containing text

Add Amount values when the course note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →435 · Counting & sums

Average completed courses

Calculate the average Amount for courses marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →436 · Counting & sums

Average courses without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →437 · Filtering & lookup

Filter completed courses

Return every course row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →438 · Filtering & lookup

Filter courses with AND

Return courses that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →439 · Filtering & lookup

Filter courses with OR

Return courses whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →440 · Filtering & lookup

Filter courses containing text

Return courses whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →441 · Filtering & lookup

Lookup a course amount

Match a course label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →442 · Filtering & lookup

Last completed course

Return the final course label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →443 · Conditions

Label completed courses

Return Done for a Complete course; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →444 · Conditions

Leave blank course results blank

Keep the result empty when the course cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →445 · Rows & arrays

Course running total

Create a cumulative Amount total that grows down the courses table.

=SUM($C$2:C2)Open recipe →446 · Counting & sums

Count completed events

Count events whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →447 · Counting & sums

Count open events

Count events that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →448 · Counting & sums

Count events by region

Count events assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →449 · Counting & sums

Count events containing text

Count events whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →450 · Counting & sums

Count non-empty events

Count filled event cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →451 · Counting & sums

Count blank event notes

Find how many events have no note entered.

=COUNTBLANK(F2:F)Open recipe →452 · Counting & sums

Count events over 1000

Count events whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →453 · Counting & sums

Count events between amounts

Count events with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →454 · Counting & sums

Count events between dates

Count events dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →455 · Counting & sums

Count unique completed events

Count distinct event labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →456 · Counting & sums

Sum completed events

Add Amount values only for events marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →457 · Counting & sums

Sum events by region

Add Amount values for events assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →458 · Counting & sums

Sum events between dates

Add Amount values for events dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →459 · Counting & sums

Sum events containing text

Add Amount values when the event note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →460 · Counting & sums

Average completed events

Calculate the average Amount for events marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →461 · Counting & sums

Average events without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →462 · Filtering & lookup

Filter completed events

Return every event row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →463 · Filtering & lookup

Filter events with AND

Return events that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →464 · Filtering & lookup

Filter events with OR

Return events whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →465 · Filtering & lookup

Filter events containing text

Return events whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →466 · Filtering & lookup

Lookup a event amount

Match a event label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →467 · Filtering & lookup

Last completed event

Return the final event label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →468 · Conditions

Label completed events

Return Done for a Complete event; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →469 · Conditions

Leave blank event results blank

Keep the result empty when the event cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →470 · Rows & arrays

Event running total

Create a cumulative Amount total that grows down the events table.

=SUM($C$2:C2)Open recipe →471 · Counting & sums

Count completed bookings

Count bookings whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →472 · Counting & sums

Count open bookings

Count bookings that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →473 · Counting & sums

Count bookings by region

Count bookings assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →474 · Counting & sums

Count bookings containing text

Count bookings whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →475 · Counting & sums

Count non-empty bookings

Count filled booking cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →476 · Counting & sums

Count blank booking notes

Find how many bookings have no note entered.

=COUNTBLANK(F2:F)Open recipe →477 · Counting & sums

Count bookings over 1000

Count bookings whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →478 · Counting & sums

Count bookings between amounts

Count bookings with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →479 · Counting & sums

Count bookings between dates

Count bookings dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →480 · Counting & sums

Count unique completed bookings

Count distinct booking labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →481 · Counting & sums

Sum completed bookings

Add Amount values only for bookings marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →482 · Counting & sums

Sum bookings by region

Add Amount values for bookings assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →483 · Counting & sums

Sum bookings between dates

Add Amount values for bookings dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →484 · Counting & sums

Sum bookings containing text

Add Amount values when the booking note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →485 · Counting & sums

Average completed bookings

Calculate the average Amount for bookings marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →486 · Counting & sums

Average bookings without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →487 · Filtering & lookup

Filter completed bookings

Return every booking row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →488 · Filtering & lookup

Filter bookings with AND

Return bookings that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →489 · Filtering & lookup

Filter bookings with OR

Return bookings whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →490 · Filtering & lookup

Filter bookings containing text

Return bookings whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →491 · Filtering & lookup

Lookup a booking amount

Match a booking label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →492 · Filtering & lookup

Last completed booking

Return the final booking label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →493 · Conditions

Label completed bookings

Return Done for a Complete booking; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →494 · Conditions

Leave blank booking results blank

Keep the result empty when the booking cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →495 · Rows & arrays

Booking running total

Create a cumulative Amount total that grows down the bookings table.

=SUM($C$2:C2)Open recipe →496 · Counting & sums

Count completed subscriptions

Count subscriptions whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →497 · Counting & sums

Count open subscriptions

Count subscriptions that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →498 · Counting & sums

Count subscriptions by region

Count subscriptions assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →499 · Counting & sums

Count subscriptions containing text

Count subscriptions whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →500 · Counting & sums

Count non-empty subscriptions

Count filled subscription cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →501 · Counting & sums

Count blank subscription notes

Find how many subscriptions have no note entered.

=COUNTBLANK(F2:F)Open recipe →502 · Counting & sums

Count subscriptions over 1000

Count subscriptions whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →503 · Counting & sums

Count subscriptions between amounts

Count subscriptions with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →504 · Counting & sums

Count subscriptions between dates

Count subscriptions dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →505 · Counting & sums

Count unique completed subscriptions

Count distinct subscription labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →506 · Counting & sums

Sum completed subscriptions

Add Amount values only for subscriptions marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →507 · Counting & sums

Sum subscriptions by region

Add Amount values for subscriptions assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →508 · Counting & sums

Sum subscriptions between dates

Add Amount values for subscriptions dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →509 · Counting & sums

Sum subscriptions containing text

Add Amount values when the subscription note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →510 · Counting & sums

Average completed subscriptions

Calculate the average Amount for subscriptions marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →511 · Counting & sums

Average subscriptions without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →512 · Filtering & lookup

Filter completed subscriptions

Return every subscription row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →513 · Filtering & lookup

Filter subscriptions with AND

Return subscriptions that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →514 · Filtering & lookup

Filter subscriptions with OR

Return subscriptions whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →515 · Filtering & lookup

Filter subscriptions containing text

Return subscriptions whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →516 · Filtering & lookup

Lookup a subscription amount

Match a subscription label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →517 · Filtering & lookup

Last completed subscription

Return the final subscription label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →518 · Conditions

Label completed subscriptions

Return Done for a Complete subscription; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →519 · Conditions

Leave blank subscription results blank

Keep the result empty when the subscription cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →520 · Rows & arrays

Subscription running total

Create a cumulative Amount total that grows down the subscriptions table.

=SUM($C$2:C2)Open recipe →521 · Counting & sums

Count completed vendors

Count vendors whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →522 · Counting & sums

Count open vendors

Count vendors that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →523 · Counting & sums

Count vendors by region

Count vendors assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →524 · Counting & sums

Count vendors containing text

Count vendors whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →525 · Counting & sums

Count non-empty vendors

Count filled vendor cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →526 · Counting & sums

Count blank vendor notes

Find how many vendors have no note entered.

=COUNTBLANK(F2:F)Open recipe →527 · Counting & sums

Count vendors over 1000

Count vendors whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →528 · Counting & sums

Count vendors between amounts

Count vendors with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →529 · Counting & sums

Count vendors between dates

Count vendors dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →530 · Counting & sums

Count unique completed vendors

Count distinct vendor labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →531 · Counting & sums

Sum completed vendors

Add Amount values only for vendors marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →532 · Counting & sums

Sum vendors by region

Add Amount values for vendors assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →533 · Counting & sums

Sum vendors between dates

Add Amount values for vendors dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →534 · Counting & sums

Sum vendors containing text

Add Amount values when the vendor note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →535 · Counting & sums

Average completed vendors

Calculate the average Amount for vendors marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →536 · Counting & sums

Average vendors without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →537 · Filtering & lookup

Filter completed vendors

Return every vendor row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →538 · Filtering & lookup

Filter vendors with AND

Return vendors that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →539 · Filtering & lookup

Filter vendors with OR

Return vendors whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →540 · Filtering & lookup

Filter vendors containing text

Return vendors whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →541 · Filtering & lookup

Lookup a vendor amount

Match a vendor label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →542 · Filtering & lookup

Last completed vendor

Return the final vendor label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →543 · Conditions

Label completed vendors

Return Done for a Complete vendor; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →544 · Conditions

Leave blank vendor results blank

Keep the result empty when the vendor cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →545 · Rows & arrays

Vendor running total

Create a cumulative Amount total that grows down the vendors table.

=SUM($C$2:C2)Open recipe →546 · Counting & sums

Count completed payments

Count payments whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →547 · Counting & sums

Count open payments

Count payments that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →548 · Counting & sums

Count payments by region

Count payments assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →549 · Counting & sums

Count payments containing text

Count payments whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →550 · Counting & sums

Count non-empty payments

Count filled payment cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →551 · Counting & sums

Count blank payment notes

Find how many payments have no note entered.

=COUNTBLANK(F2:F)Open recipe →552 · Counting & sums

Count payments over 1000

Count payments whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →553 · Counting & sums

Count payments between amounts

Count payments with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →554 · Counting & sums

Count payments between dates

Count payments dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →555 · Counting & sums

Count unique completed payments

Count distinct payment labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →556 · Counting & sums

Sum completed payments

Add Amount values only for payments marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →557 · Counting & sums

Sum payments by region

Add Amount values for payments assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →558 · Counting & sums

Sum payments between dates

Add Amount values for payments dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →559 · Counting & sums

Sum payments containing text

Add Amount values when the payment note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →560 · Counting & sums

Average completed payments

Calculate the average Amount for payments marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →561 · Counting & sums

Average payments without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →562 · Filtering & lookup

Filter completed payments

Return every payment row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →563 · Filtering & lookup

Filter payments with AND

Return payments that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →564 · Filtering & lookup

Filter payments with OR

Return payments whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →565 · Filtering & lookup

Filter payments containing text

Return payments whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →566 · Filtering & lookup

Lookup a payment amount

Match a payment label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →567 · Filtering & lookup

Last completed payment

Return the final payment label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →568 · Conditions

Label completed payments

Return Done for a Complete payment; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →569 · Conditions

Leave blank payment results blank

Keep the result empty when the payment cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →570 · Rows & arrays

Payment running total

Create a cumulative Amount total that grows down the payments table.

=SUM($C$2:C2)Open recipe →571 · Counting & sums

Count completed transactions

Count transactions whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →572 · Counting & sums

Count open transactions

Count transactions that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →573 · Counting & sums

Count transactions by region

Count transactions assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →574 · Counting & sums

Count transactions containing text

Count transactions whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →575 · Counting & sums

Count non-empty transactions

Count filled transaction cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →576 · Counting & sums

Count blank transaction notes

Find how many transactions have no note entered.

=COUNTBLANK(F2:F)Open recipe →577 · Counting & sums

Count transactions over 1000

Count transactions whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →578 · Counting & sums

Count transactions between amounts

Count transactions with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →579 · Counting & sums

Count transactions between dates

Count transactions dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →580 · Counting & sums

Count unique completed transactions

Count distinct transaction labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →581 · Counting & sums

Sum completed transactions

Add Amount values only for transactions marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →582 · Counting & sums

Sum transactions by region

Add Amount values for transactions assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →583 · Counting & sums

Sum transactions between dates

Add Amount values for transactions dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →584 · Counting & sums

Sum transactions containing text

Add Amount values when the transaction note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →585 · Counting & sums

Average completed transactions

Calculate the average Amount for transactions marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →586 · Counting & sums

Average transactions without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →587 · Filtering & lookup

Filter completed transactions

Return every transaction row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →588 · Filtering & lookup

Filter transactions with AND

Return transactions that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →589 · Filtering & lookup

Filter transactions with OR

Return transactions whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →590 · Filtering & lookup

Filter transactions containing text

Return transactions whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →591 · Filtering & lookup

Lookup a transaction amount

Match a transaction label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →592 · Filtering & lookup

Last completed transaction

Return the final transaction label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →593 · Conditions

Label completed transactions

Return Done for a Complete transaction; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →594 · Conditions

Leave blank transaction results blank

Keep the result empty when the transaction cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →595 · Rows & arrays

Transaction running total

Create a cumulative Amount total that grows down the transactions table.

=SUM($C$2:C2)Open recipe →596 · Counting & sums

Count completed budget items

Count budget items whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →597 · Counting & sums

Count open budget items

Count budget items that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →598 · Counting & sums

Count budget items by region

Count budget items assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →599 · Counting & sums

Count budget items containing text

Count budget items whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →600 · Counting & sums

Count non-empty budget items

Count filled budget item cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →601 · Counting & sums

Count blank budget item notes

Find how many budget items have no note entered.

=COUNTBLANK(F2:F)Open recipe →602 · Counting & sums

Count budget items over 1000

Count budget items whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →603 · Counting & sums

Count budget items between amounts

Count budget items with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →604 · Counting & sums

Count budget items between dates

Count budget items dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →605 · Counting & sums

Count unique completed budget items

Count distinct budget item labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →606 · Counting & sums

Sum completed budget items

Add Amount values only for budget items marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →607 · Counting & sums

Sum budget items by region

Add Amount values for budget items assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →608 · Counting & sums

Sum budget items between dates

Add Amount values for budget items dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →609 · Counting & sums

Sum budget items containing text

Add Amount values when the budget item note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →610 · Counting & sums

Average completed budget items

Calculate the average Amount for budget items marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →611 · Counting & sums

Average budget items without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →612 · Filtering & lookup

Filter completed budget items

Return every budget item row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →613 · Filtering & lookup

Filter budget items with AND

Return budget items that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →614 · Filtering & lookup

Filter budget items with OR

Return budget items whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →615 · Filtering & lookup

Filter budget items containing text

Return budget items whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →616 · Filtering & lookup

Lookup a budget item amount

Match a budget item label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →617 · Filtering & lookup

Last completed budget item

Return the final budget item label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →618 · Conditions

Label completed budget items

Return Done for a Complete budget item; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →619 · Conditions

Leave blank budget item results blank

Keep the result empty when the budget item cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →620 · Rows & arrays

Budget item running total

Create a cumulative Amount total that grows down the budget items table.

=SUM($C$2:C2)Open recipe →621 · Counting & sums

Count completed campaigns

Count campaigns whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →622 · Counting & sums

Count open campaigns

Count campaigns that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →623 · Counting & sums

Count campaigns by region

Count campaigns assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →624 · Counting & sums

Count campaigns containing text

Count campaigns whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →625 · Counting & sums

Count non-empty campaigns

Count filled campaign cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →626 · Counting & sums

Count blank campaign notes

Find how many campaigns have no note entered.

=COUNTBLANK(F2:F)Open recipe →627 · Counting & sums

Count campaigns over 1000

Count campaigns whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →628 · Counting & sums

Count campaigns between amounts

Count campaigns with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →629 · Counting & sums

Count campaigns between dates

Count campaigns dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →630 · Counting & sums

Count unique completed campaigns

Count distinct campaign labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →631 · Counting & sums

Sum completed campaigns

Add Amount values only for campaigns marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →632 · Counting & sums

Sum campaigns by region

Add Amount values for campaigns assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →633 · Counting & sums

Sum campaigns between dates

Add Amount values for campaigns dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →634 · Counting & sums

Sum campaigns containing text

Add Amount values when the campaign note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →635 · Counting & sums

Average completed campaigns

Calculate the average Amount for campaigns marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →636 · Counting & sums

Average campaigns without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →637 · Filtering & lookup

Filter completed campaigns

Return every campaign row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →638 · Filtering & lookup

Filter campaigns with AND

Return campaigns that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →639 · Filtering & lookup

Filter campaigns with OR

Return campaigns whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →640 · Filtering & lookup

Filter campaigns containing text

Return campaigns whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →641 · Filtering & lookup

Lookup a campaign amount

Match a campaign label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →642 · Filtering & lookup

Last completed campaign

Return the final campaign label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →643 · Conditions

Label completed campaigns

Return Done for a Complete campaign; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →644 · Conditions

Leave blank campaign results blank

Keep the result empty when the campaign cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →645 · Rows & arrays

Campaign running total

Create a cumulative Amount total that grows down the campaigns table.

=SUM($C$2:C2)Open recipe →646 · Counting & sums

Count completed content items

Count content items whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →647 · Counting & sums

Count open content items

Count content items that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →648 · Counting & sums

Count content items by region

Count content items assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →649 · Counting & sums

Count content items containing text

Count content items whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →650 · Counting & sums

Count non-empty content items

Count filled content item cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →651 · Counting & sums

Count blank content item notes

Find how many content items have no note entered.

=COUNTBLANK(F2:F)Open recipe →652 · Counting & sums

Count content items over 1000

Count content items whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →653 · Counting & sums

Count content items between amounts

Count content items with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →654 · Counting & sums

Count content items between dates

Count content items dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →655 · Counting & sums

Count unique completed content items

Count distinct content item labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →656 · Counting & sums

Sum completed content items

Add Amount values only for content items marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →657 · Counting & sums

Sum content items by region

Add Amount values for content items assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →658 · Counting & sums

Sum content items between dates

Add Amount values for content items dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →659 · Counting & sums

Sum content items containing text

Add Amount values when the content item note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →660 · Counting & sums

Average completed content items

Calculate the average Amount for content items marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →661 · Counting & sums

Average content items without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →662 · Filtering & lookup

Filter completed content items

Return every content item row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →663 · Filtering & lookup

Filter content items with AND

Return content items that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →664 · Filtering & lookup

Filter content items with OR

Return content items whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →665 · Filtering & lookup

Filter content items containing text

Return content items whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →666 · Filtering & lookup

Lookup a content item amount

Match a content item label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →667 · Filtering & lookup

Last completed content item

Return the final content item label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →668 · Conditions

Label completed content items

Return Done for a Complete content item; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →669 · Conditions

Leave blank content item results blank

Keep the result empty when the content item cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →670 · Rows & arrays

Content item running total

Create a cumulative Amount total that grows down the content items table.

=SUM($C$2:C2)Open recipe →671 · Counting & sums

Count completed website pages

Count website pages whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →672 · Counting & sums

Count open website pages

Count website pages that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →673 · Counting & sums

Count website pages by region

Count website pages assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →674 · Counting & sums

Count website pages containing text

Count website pages whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →675 · Counting & sums

Count non-empty website pages

Count filled page cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →676 · Counting & sums

Count blank website page notes

Find how many website pages have no note entered.

=COUNTBLANK(F2:F)Open recipe →677 · Counting & sums

Count website pages over 1000

Count website pages whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →678 · Counting & sums

Count website pages between amounts

Count website pages with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →679 · Counting & sums

Count website pages between dates

Count website pages dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →680 · Counting & sums

Count unique completed website pages

Count distinct page labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →681 · Counting & sums

Sum completed website pages

Add Amount values only for website pages marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →682 · Counting & sums

Sum website pages by region

Add Amount values for website pages assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →683 · Counting & sums

Sum website pages between dates

Add Amount values for website pages dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →684 · Counting & sums

Sum website pages containing text

Add Amount values when the website page note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →685 · Counting & sums

Average completed website pages

Calculate the average Amount for website pages marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →686 · Counting & sums

Average website pages without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →687 · Filtering & lookup

Filter completed website pages

Return every website page row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →688 · Filtering & lookup

Filter website pages with AND

Return website pages that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →689 · Filtering & lookup

Filter website pages with OR

Return website pages whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →690 · Filtering & lookup

Filter website pages containing text

Return website pages whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →691 · Filtering & lookup

Lookup a website page amount

Match a page label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →692 · Filtering & lookup

Last completed website page

Return the final page label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →693 · Conditions

Label completed website pages

Return Done for a Complete website page; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →694 · Conditions

Leave blank website page results blank

Keep the result empty when the page cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →695 · Rows & arrays

Page running total

Create a cumulative Amount total that grows down the website pages table.

=SUM($C$2:C2)Open recipe →696 · Counting & sums

Count completed keywords

Count keywords whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →697 · Counting & sums

Count open keywords

Count keywords that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →698 · Counting & sums

Count keywords by region

Count keywords assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →699 · Counting & sums

Count keywords containing text

Count keywords whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →700 · Counting & sums

Count non-empty keywords

Count filled keyword cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →701 · Counting & sums

Count blank keyword notes

Find how many keywords have no note entered.

=COUNTBLANK(F2:F)Open recipe →702 · Counting & sums

Count keywords over 1000

Count keywords whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →703 · Counting & sums

Count keywords between amounts

Count keywords with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →704 · Counting & sums

Count keywords between dates

Count keywords dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →705 · Counting & sums

Count unique completed keywords

Count distinct keyword labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →706 · Counting & sums

Sum completed keywords

Add Amount values only for keywords marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →707 · Counting & sums

Sum keywords by region

Add Amount values for keywords assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →708 · Counting & sums

Sum keywords between dates

Add Amount values for keywords dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →709 · Counting & sums

Sum keywords containing text

Add Amount values when the keyword note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →710 · Counting & sums

Average completed keywords

Calculate the average Amount for keywords marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →711 · Counting & sums

Average keywords without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →712 · Filtering & lookup

Filter completed keywords

Return every keyword row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →713 · Filtering & lookup

Filter keywords with AND

Return keywords that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →714 · Filtering & lookup

Filter keywords with OR

Return keywords whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →715 · Filtering & lookup

Filter keywords containing text

Return keywords whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →716 · Filtering & lookup

Lookup a keyword amount

Match a keyword label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →717 · Filtering & lookup

Last completed keyword

Return the final keyword label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →718 · Conditions

Label completed keywords

Return Done for a Complete keyword; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →719 · Conditions

Leave blank keyword results blank

Keep the result empty when the keyword cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →720 · Rows & arrays

Keyword running total

Create a cumulative Amount total that grows down the keywords table.

=SUM($C$2:C2)Open recipe →721 · Counting & sums

Count completed survey responses

Count survey responses whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →722 · Counting & sums

Count open survey responses

Count survey responses that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →723 · Counting & sums

Count survey responses by region

Count survey responses assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →724 · Counting & sums

Count survey responses containing text

Count survey responses whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →725 · Counting & sums

Count non-empty survey responses

Count filled response cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →726 · Counting & sums

Count blank survey response notes

Find how many survey responses have no note entered.

=COUNTBLANK(F2:F)Open recipe →727 · Counting & sums

Count survey responses over 1000

Count survey responses whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →728 · Counting & sums

Count survey responses between amounts

Count survey responses with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →729 · Counting & sums

Count survey responses between dates

Count survey responses dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →730 · Counting & sums

Count unique completed survey responses

Count distinct response labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →731 · Counting & sums

Sum completed survey responses

Add Amount values only for survey responses marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →732 · Counting & sums

Sum survey responses by region

Add Amount values for survey responses assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →733 · Counting & sums

Sum survey responses between dates

Add Amount values for survey responses dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →734 · Counting & sums

Sum survey responses containing text

Add Amount values when the survey response note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →735 · Counting & sums

Average completed survey responses

Calculate the average Amount for survey responses marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →736 · Counting & sums

Average survey responses without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →737 · Filtering & lookup

Filter completed survey responses

Return every survey response row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →738 · Filtering & lookup

Filter survey responses with AND

Return survey responses that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →739 · Filtering & lookup

Filter survey responses with OR

Return survey responses whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →740 · Filtering & lookup

Filter survey responses containing text

Return survey responses whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →741 · Filtering & lookup

Lookup a survey response amount

Match a response label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →742 · Filtering & lookup

Last completed survey response

Return the final response label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →743 · Conditions

Label completed survey responses

Return Done for a Complete survey response; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →744 · Conditions

Leave blank survey response results blank

Keep the result empty when the response cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →745 · Rows & arrays

Response running total

Create a cumulative Amount total that grows down the survey responses table.

=SUM($C$2:C2)Open recipe →746 · Counting & sums

Count completed quality checks

Count quality checks whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →747 · Counting & sums

Count open quality checks

Count quality checks that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →748 · Counting & sums

Count quality checks by region

Count quality checks assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →749 · Counting & sums

Count quality checks containing text

Count quality checks whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →750 · Counting & sums

Count non-empty quality checks

Count filled check cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →751 · Counting & sums

Count blank quality check notes

Find how many quality checks have no note entered.

=COUNTBLANK(F2:F)Open recipe →752 · Counting & sums

Count quality checks over 1000

Count quality checks whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →753 · Counting & sums

Count quality checks between amounts

Count quality checks with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →754 · Counting & sums

Count quality checks between dates

Count quality checks dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →755 · Counting & sums

Count unique completed quality checks

Count distinct check labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →756 · Counting & sums

Sum completed quality checks

Add Amount values only for quality checks marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →757 · Counting & sums

Sum quality checks by region

Add Amount values for quality checks assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →758 · Counting & sums

Sum quality checks between dates

Add Amount values for quality checks dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →759 · Counting & sums

Sum quality checks containing text

Add Amount values when the quality check note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →760 · Counting & sums

Average completed quality checks

Calculate the average Amount for quality checks marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →761 · Counting & sums

Average quality checks without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →762 · Filtering & lookup

Filter completed quality checks

Return every quality check row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →763 · Filtering & lookup

Filter quality checks with AND

Return quality checks that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →764 · Filtering & lookup

Filter quality checks with OR

Return quality checks whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →765 · Filtering & lookup

Filter quality checks containing text

Return quality checks whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →766 · Filtering & lookup

Lookup a quality check amount

Match a check label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →767 · Filtering & lookup

Last completed quality check

Return the final check label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →768 · Conditions

Label completed quality checks

Return Done for a Complete quality check; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →769 · Conditions

Leave blank quality check results blank

Keep the result empty when the check cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →770 · Rows & arrays

Check running total

Create a cumulative Amount total that grows down the quality checks table.

=SUM($C$2:C2)Open recipe →771 · Counting & sums

Count completed work orders

Count work orders whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →772 · Counting & sums

Count open work orders

Count work orders that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →773 · Counting & sums

Count work orders by region

Count work orders assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →774 · Counting & sums

Count work orders containing text

Count work orders whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →775 · Counting & sums

Count non-empty work orders

Count filled work order cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →776 · Counting & sums

Count blank work order notes

Find how many work orders have no note entered.

=COUNTBLANK(F2:F)Open recipe →777 · Counting & sums

Count work orders over 1000

Count work orders whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →778 · Counting & sums

Count work orders between amounts

Count work orders with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →779 · Counting & sums

Count work orders between dates

Count work orders dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →780 · Counting & sums

Count unique completed work orders

Count distinct work order labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →781 · Counting & sums

Sum completed work orders

Add Amount values only for work orders marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →782 · Counting & sums

Sum work orders by region

Add Amount values for work orders assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →783 · Counting & sums

Sum work orders between dates

Add Amount values for work orders dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →784 · Counting & sums

Sum work orders containing text

Add Amount values when the work order note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →785 · Counting & sums

Average completed work orders

Calculate the average Amount for work orders marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →786 · Counting & sums

Average work orders without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →787 · Filtering & lookup

Filter completed work orders

Return every work order row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →788 · Filtering & lookup

Filter work orders with AND

Return work orders that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →789 · Filtering & lookup

Filter work orders with OR

Return work orders whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →790 · Filtering & lookup

Filter work orders containing text

Return work orders whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →791 · Filtering & lookup

Lookup a work order amount

Match a work order label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →792 · Filtering & lookup

Last completed work order

Return the final work order label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →793 · Conditions

Label completed work orders

Return Done for a Complete work order; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →794 · Conditions

Leave blank work order results blank

Keep the result empty when the work order cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →795 · Rows & arrays

Work order running total

Create a cumulative Amount total that grows down the work orders table.

=SUM($C$2:C2)Open recipe →796 · Counting & sums

Count completed properties

Count properties whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →797 · Counting & sums

Count open properties

Count properties that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →798 · Counting & sums

Count properties by region

Count properties assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →799 · Counting & sums

Count properties containing text

Count properties whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →800 · Counting & sums

Count non-empty properties

Count filled property cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →801 · Counting & sums

Count blank property notes

Find how many properties have no note entered.

=COUNTBLANK(F2:F)Open recipe →802 · Counting & sums

Count properties over 1000

Count properties whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →803 · Counting & sums

Count properties between amounts

Count properties with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →804 · Counting & sums

Count properties between dates

Count properties dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →805 · Counting & sums

Count unique completed properties

Count distinct property labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →806 · Counting & sums

Sum completed properties

Add Amount values only for properties marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →807 · Counting & sums

Sum properties by region

Add Amount values for properties assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →808 · Counting & sums

Sum properties between dates

Add Amount values for properties dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →809 · Counting & sums

Sum properties containing text

Add Amount values when the property note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →810 · Counting & sums

Average completed properties

Calculate the average Amount for properties marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →811 · Counting & sums

Average properties without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →812 · Filtering & lookup

Filter completed properties

Return every property row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →813 · Filtering & lookup

Filter properties with AND

Return properties that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →814 · Filtering & lookup

Filter properties with OR

Return properties whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →815 · Filtering & lookup

Filter properties containing text

Return properties whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →816 · Filtering & lookup

Lookup a property amount

Match a property label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →817 · Filtering & lookup

Last completed property

Return the final property label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →818 · Conditions

Label completed properties

Return Done for a Complete property; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →819 · Conditions

Leave blank property results blank

Keep the result empty when the property cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →820 · Rows & arrays

Property running total

Create a cumulative Amount total that grows down the properties table.

=SUM($C$2:C2)Open recipe →821 · Counting & sums

Count completed rentals

Count rentals whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →822 · Counting & sums

Count open rentals

Count rentals that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →823 · Counting & sums

Count rentals by region

Count rentals assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →824 · Counting & sums

Count rentals containing text

Count rentals whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →825 · Counting & sums

Count non-empty rentals

Count filled rental cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →826 · Counting & sums

Count blank rental notes

Find how many rentals have no note entered.

=COUNTBLANK(F2:F)Open recipe →827 · Counting & sums

Count rentals over 1000

Count rentals whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →828 · Counting & sums

Count rentals between amounts

Count rentals with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →829 · Counting & sums

Count rentals between dates

Count rentals dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →830 · Counting & sums

Count unique completed rentals

Count distinct rental labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →831 · Counting & sums

Sum completed rentals

Add Amount values only for rentals marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →832 · Counting & sums

Sum rentals by region

Add Amount values for rentals assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →833 · Counting & sums

Sum rentals between dates

Add Amount values for rentals dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →834 · Counting & sums

Sum rentals containing text

Add Amount values when the rental note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →835 · Counting & sums

Average completed rentals

Calculate the average Amount for rentals marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →836 · Counting & sums

Average rentals without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →837 · Filtering & lookup

Filter completed rentals

Return every rental row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →838 · Filtering & lookup

Filter rentals with AND

Return rentals that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →839 · Filtering & lookup

Filter rentals with OR

Return rentals whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →840 · Filtering & lookup

Filter rentals containing text

Return rentals whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →841 · Filtering & lookup

Lookup a rental amount

Match a rental label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →842 · Filtering & lookup

Last completed rental

Return the final rental label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →843 · Conditions

Label completed rentals

Return Done for a Complete rental; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →844 · Conditions

Leave blank rental results blank

Keep the result empty when the rental cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →845 · Rows & arrays

Rental running total

Create a cumulative Amount total that grows down the rentals table.

=SUM($C$2:C2)Open recipe →846 · Counting & sums

Count completed assets

Count assets whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →847 · Counting & sums

Count open assets

Count assets that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →848 · Counting & sums

Count assets by region

Count assets assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →849 · Counting & sums

Count assets containing text

Count assets whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →850 · Counting & sums

Count non-empty assets

Count filled asset cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →851 · Counting & sums

Count blank asset notes

Find how many assets have no note entered.

=COUNTBLANK(F2:F)Open recipe →852 · Counting & sums

Count assets over 1000

Count assets whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →853 · Counting & sums

Count assets between amounts

Count assets with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →854 · Counting & sums

Count assets between dates

Count assets dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →855 · Counting & sums

Count unique completed assets

Count distinct asset labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →856 · Counting & sums

Sum completed assets

Add Amount values only for assets marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →857 · Counting & sums

Sum assets by region

Add Amount values for assets assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →858 · Counting & sums

Sum assets between dates

Add Amount values for assets dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →859 · Counting & sums

Sum assets containing text

Add Amount values when the asset note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →860 · Counting & sums

Average completed assets

Calculate the average Amount for assets marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →861 · Counting & sums

Average assets without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →862 · Filtering & lookup

Filter completed assets

Return every asset row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →863 · Filtering & lookup

Filter assets with AND

Return assets that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →864 · Filtering & lookup

Filter assets with OR

Return assets whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →865 · Filtering & lookup

Filter assets containing text

Return assets whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →866 · Filtering & lookup

Lookup a asset amount

Match a asset label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →867 · Filtering & lookup

Last completed asset

Return the final asset label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →868 · Conditions

Label completed assets

Return Done for a Complete asset; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →869 · Conditions

Leave blank asset results blank

Keep the result empty when the asset cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →870 · Rows & arrays

Asset running total

Create a cumulative Amount total that grows down the assets table.

=SUM($C$2:C2)Open recipe →871 · Counting & sums

Count completed accounts

Count accounts whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →872 · Counting & sums

Count open accounts

Count accounts that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →873 · Counting & sums

Count accounts by region

Count accounts assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →874 · Counting & sums

Count accounts containing text

Count accounts whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →875 · Counting & sums

Count non-empty accounts

Count filled account cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →876 · Counting & sums

Count blank account notes

Find how many accounts have no note entered.

=COUNTBLANK(F2:F)Open recipe →877 · Counting & sums

Count accounts over 1000

Count accounts whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →878 · Counting & sums

Count accounts between amounts

Count accounts with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →879 · Counting & sums

Count accounts between dates

Count accounts dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →880 · Counting & sums

Count unique completed accounts

Count distinct account labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →881 · Counting & sums

Sum completed accounts

Add Amount values only for accounts marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →882 · Counting & sums

Sum accounts by region

Add Amount values for accounts assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →883 · Counting & sums

Sum accounts between dates

Add Amount values for accounts dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →884 · Counting & sums

Sum accounts containing text

Add Amount values when the account note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →885 · Counting & sums

Average completed accounts

Calculate the average Amount for accounts marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →886 · Counting & sums

Average accounts without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →887 · Filtering & lookup

Filter completed accounts

Return every account row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →888 · Filtering & lookup

Filter accounts with AND

Return accounts that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →889 · Filtering & lookup

Filter accounts with OR

Return accounts whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →890 · Filtering & lookup

Filter accounts containing text

Return accounts whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →891 · Filtering & lookup

Lookup a account amount

Match a account label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →892 · Filtering & lookup

Last completed account

Return the final account label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →893 · Conditions

Label completed accounts

Return Done for a Complete account; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →894 · Conditions

Leave blank account results blank

Keep the result empty when the account cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →895 · Rows & arrays

Account running total

Create a cumulative Amount total that grows down the accounts table.

=SUM($C$2:C2)Open recipe →896 · Counting & sums

Count completed contracts

Count contracts whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →897 · Counting & sums

Count open contracts

Count contracts that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →898 · Counting & sums

Count contracts by region

Count contracts assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →899 · Counting & sums

Count contracts containing text

Count contracts whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →900 · Counting & sums

Count non-empty contracts

Count filled contract cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →901 · Counting & sums

Count blank contract notes

Find how many contracts have no note entered.

=COUNTBLANK(F2:F)Open recipe →902 · Counting & sums

Count contracts over 1000

Count contracts whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →903 · Counting & sums

Count contracts between amounts

Count contracts with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →904 · Counting & sums

Count contracts between dates

Count contracts dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →905 · Counting & sums

Count unique completed contracts

Count distinct contract labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →906 · Counting & sums

Sum completed contracts

Add Amount values only for contracts marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →907 · Counting & sums

Sum contracts by region

Add Amount values for contracts assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →908 · Counting & sums

Sum contracts between dates

Add Amount values for contracts dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →909 · Counting & sums

Sum contracts containing text

Add Amount values when the contract note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →910 · Counting & sums

Average completed contracts

Calculate the average Amount for contracts marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →911 · Counting & sums

Average contracts without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →912 · Filtering & lookup

Filter completed contracts

Return every contract row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →913 · Filtering & lookup

Filter contracts with AND

Return contracts that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →914 · Filtering & lookup

Filter contracts with OR

Return contracts whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →915 · Filtering & lookup

Filter contracts containing text

Return contracts whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →916 · Filtering & lookup

Lookup a contract amount

Match a contract label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →917 · Filtering & lookup

Last completed contract

Return the final contract label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →918 · Conditions

Label completed contracts

Return Done for a Complete contract; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →919 · Conditions

Leave blank contract results blank

Keep the result empty when the contract cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →920 · Rows & arrays

Contract running total

Create a cumulative Amount total that grows down the contracts table.

=SUM($C$2:C2)Open recipe →921 · Counting & sums

Count completed meetings

Count meetings whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →922 · Counting & sums

Count open meetings

Count meetings that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →923 · Counting & sums

Count meetings by region

Count meetings assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →924 · Counting & sums

Count meetings containing text

Count meetings whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →925 · Counting & sums

Count non-empty meetings

Count filled meeting cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →926 · Counting & sums

Count blank meeting notes

Find how many meetings have no note entered.

=COUNTBLANK(F2:F)Open recipe →927 · Counting & sums

Count meetings over 1000

Count meetings whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →928 · Counting & sums

Count meetings between amounts

Count meetings with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →929 · Counting & sums

Count meetings between dates

Count meetings dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →930 · Counting & sums

Count unique completed meetings

Count distinct meeting labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →931 · Counting & sums

Sum completed meetings

Add Amount values only for meetings marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →932 · Counting & sums

Sum meetings by region

Add Amount values for meetings assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →933 · Counting & sums

Sum meetings between dates

Add Amount values for meetings dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →934 · Counting & sums

Sum meetings containing text

Add Amount values when the meeting note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →935 · Counting & sums

Average completed meetings

Calculate the average Amount for meetings marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →936 · Counting & sums

Average meetings without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →937 · Filtering & lookup

Filter completed meetings

Return every meeting row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →938 · Filtering & lookup

Filter meetings with AND

Return meetings that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →939 · Filtering & lookup

Filter meetings with OR

Return meetings whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →940 · Filtering & lookup

Filter meetings containing text

Return meetings whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →941 · Filtering & lookup

Lookup a meeting amount

Match a meeting label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →942 · Filtering & lookup

Last completed meeting

Return the final meeting label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →943 · Conditions

Label completed meetings

Return Done for a Complete meeting; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →944 · Conditions

Leave blank meeting results blank

Keep the result empty when the meeting cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →945 · Rows & arrays

Meeting running total

Create a cumulative Amount total that grows down the meetings table.

=SUM($C$2:C2)Open recipe →946 · Counting & sums

Count completed timesheet entries

Count timesheet entries whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →947 · Counting & sums

Count open timesheet entries

Count timesheet entries that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →948 · Counting & sums

Count timesheet entries by region

Count timesheet entries assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →949 · Counting & sums

Count timesheet entries containing text

Count timesheet entries whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →950 · Counting & sums

Count non-empty timesheet entries

Count filled entry cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →951 · Counting & sums

Count blank timesheet entry notes

Find how many timesheet entries have no note entered.

=COUNTBLANK(F2:F)Open recipe →952 · Counting & sums

Count timesheet entries over 1000

Count timesheet entries whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →953 · Counting & sums

Count timesheet entries between amounts

Count timesheet entries with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →954 · Counting & sums

Count timesheet entries between dates

Count timesheet entries dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →955 · Counting & sums

Count unique completed timesheet entries

Count distinct entry labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →956 · Counting & sums

Sum completed timesheet entries

Add Amount values only for timesheet entries marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →957 · Counting & sums

Sum timesheet entries by region

Add Amount values for timesheet entries assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →958 · Counting & sums

Sum timesheet entries between dates

Add Amount values for timesheet entries dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →959 · Counting & sums

Sum timesheet entries containing text

Add Amount values when the timesheet entry note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →960 · Counting & sums

Average completed timesheet entries

Calculate the average Amount for timesheet entries marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →961 · Counting & sums

Average timesheet entries without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →962 · Filtering & lookup

Filter completed timesheet entries

Return every timesheet entry row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →963 · Filtering & lookup

Filter timesheet entries with AND

Return timesheet entries that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →964 · Filtering & lookup

Filter timesheet entries with OR

Return timesheet entries whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →965 · Filtering & lookup

Filter timesheet entries containing text

Return timesheet entries whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →966 · Filtering & lookup

Lookup a timesheet entry amount

Match a entry label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →967 · Filtering & lookup

Last completed timesheet entry

Return the final entry label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →968 · Conditions

Label completed timesheet entries

Return Done for a Complete timesheet entry; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →969 · Conditions

Leave blank timesheet entry results blank

Keep the result empty when the entry cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →970 · Rows & arrays

Entry running total

Create a cumulative Amount total that grows down the timesheet entries table.

=SUM($C$2:C2)Open recipe →971 · Counting & sums

Count completed purchase orders

Count purchase orders whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →972 · Counting & sums

Count open purchase orders

Count purchase orders that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →973 · Counting & sums

Count purchase orders by region

Count purchase orders assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →974 · Counting & sums

Count purchase orders containing text

Count purchase orders whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →975 · Counting & sums

Count non-empty purchase orders

Count filled purchase order cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →976 · Counting & sums

Count blank purchase order notes

Find how many purchase orders have no note entered.

=COUNTBLANK(F2:F)Open recipe →977 · Counting & sums

Count purchase orders over 1000

Count purchase orders whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →978 · Counting & sums

Count purchase orders between amounts

Count purchase orders with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →979 · Counting & sums

Count purchase orders between dates

Count purchase orders dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →980 · Counting & sums

Count unique completed purchase orders

Count distinct purchase order labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →981 · Counting & sums

Sum completed purchase orders

Add Amount values only for purchase orders marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →982 · Counting & sums

Sum purchase orders by region

Add Amount values for purchase orders assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →983 · Counting & sums

Sum purchase orders between dates

Add Amount values for purchase orders dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →984 · Counting & sums

Sum purchase orders containing text

Add Amount values when the purchase order note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →985 · Counting & sums

Average completed purchase orders

Calculate the average Amount for purchase orders marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →986 · Counting & sums

Average purchase orders without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →987 · Filtering & lookup

Filter completed purchase orders

Return every purchase order row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →988 · Filtering & lookup

Filter purchase orders with AND

Return purchase orders that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →989 · Filtering & lookup

Filter purchase orders with OR

Return purchase orders whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →990 · Filtering & lookup

Filter purchase orders containing text

Return purchase orders whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →991 · Filtering & lookup

Lookup a purchase order amount

Match a purchase order label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →992 · Filtering & lookup

Last completed purchase order

Return the final purchase order label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →993 · Conditions

Label completed purchase orders

Return Done for a Complete purchase order; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →994 · Conditions

Leave blank purchase order results blank

Keep the result empty when the purchase order cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →995 · Rows & arrays

Purchase order running total

Create a cumulative Amount total that grows down the purchase orders table.

=SUM($C$2:C2)Open recipe →996 · Counting & sums

Count completed deliveries

Count deliveries whose status is Complete without counting open or review rows.

=COUNTIF(E2:E,"Complete")Open recipe →997 · Counting & sums

Count open deliveries

Count deliveries that still have an Open status.

=COUNTIF(E2:E,"Open")Open recipe →998 · Counting & sums

Count deliveries by region

Count deliveries assigned to the North region and change the criterion for another region.

=COUNTIF(B2:B,"North")Open recipe →999 · Counting & sums

Count deliveries containing text

Count deliveries whose notes contain the word urgent anywhere in the cell.

=COUNTIF(F2:F,"*urgent*")Open recipe →1000 · Counting & sums

Count non-empty deliveries

Count filled delivery cells while ignoring empty rows.

=COUNTIF(A2:A,"<>")Open recipe →1001 · Counting & sums

Count blank delivery notes

Find how many deliveries have no note entered.

=COUNTBLANK(F2:F)Open recipe →1002 · Counting & sums

Count deliveries over 1000

Count deliveries whose Amount is greater than 1,000.

=COUNTIF(C2:C,">1000")Open recipe →1003 · Counting & sums

Count deliveries between amounts

Count deliveries with Amount values from 500 through 1,500.

=COUNTIFS(C2:C,">=500",C2:C,"<=1500")Open recipe →1004 · Counting & sums

Count deliveries between dates

Count deliveries dated from July 1 through July 31, 2026.

=COUNTIFS(D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →1005 · Counting & sums

Count unique completed deliveries

Count distinct delivery labels after keeping only Complete rows.

=COUNTUNIQUE(FILTER(A2:A,E2:E="Complete",A2:A<>""))Open recipe →1006 · Counting & sums

Sum completed deliveries

Add Amount values only for deliveries marked Complete.

=SUMIF(E2:E,"Complete",C2:C)Open recipe →1007 · Counting & sums

Sum deliveries by region

Add Amount values for deliveries assigned to North.

=SUMIF(B2:B,"North",C2:C)Open recipe →1008 · Counting & sums

Sum deliveries between dates

Add Amount values for deliveries dated within July 2026.

=SUMIFS(C2:C,D2:D,">="&DATE(2026,7,1),D2:D,"<="&DATE(2026,7,31))Open recipe →1009 · Counting & sums

Sum deliveries containing text

Add Amount values when the delivery note contains urgent.

=SUMIF(F2:F,"*urgent*",C2:C)Open recipe →1010 · Counting & sums

Average completed deliveries

Calculate the average Amount for deliveries marked Complete.

=AVERAGEIF(E2:E,"Complete",C2:C)Open recipe →1011 · Counting & sums

Average deliveries without zeros

Average the Amount column while leaving zero values out of the calculation.

=AVERAGEIF(C2:C,"<>0")Open recipe →1012 · Filtering & lookup

Filter completed deliveries

Return every delivery row whose status is Complete.

=FILTER(A2:F,E2:E="Complete")Open recipe →1013 · Filtering & lookup

Filter deliveries with AND

Return deliveries that are both Complete and assigned to North.

=FILTER(A2:F,E2:E="Complete",B2:B="North")Open recipe →1014 · Filtering & lookup

Filter deliveries with OR

Return deliveries whose status is Complete or Review.

=FILTER(A2:F,(E2:E="Complete")+(E2:E="Review"))Open recipe →1015 · Filtering & lookup

Filter deliveries containing text

Return deliveries whose Notes cell contains urgent.

=FILTER(A2:F,REGEXMATCH(LOWER(F2:F),"urgent"))Open recipe →1016 · Filtering & lookup

Lookup a delivery amount

Match a delivery label and return its Amount from the same table.

=XLOOKUP(H2,A2:A,C2:C,"Not found")Open recipe →1017 · Filtering & lookup

Last completed delivery

Return the final delivery label whose status is Complete.

=XLOOKUP("Complete",E2:E,A2:A,"Not found",0,-1)Open recipe →1018 · Conditions

Label completed deliveries

Return Done for a Complete delivery; otherwise return Pending.

=IF(E2="Complete","Done","Pending")Open recipe →1019 · Conditions

Leave blank delivery results blank

Keep the result empty when the delivery cell is blank; otherwise double Amount.

=IF(A2="","",C2*2)Open recipe →1020 · Rows & arrays

Delivery running total

Create a cumulative Amount total that grows down the deliveries table.

=SUM($C$2:C2)Open recipe →