> For the complete documentation index, see [llms.txt](https://docs.coffbox.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coffbox.com/usage-examples/order-profit-statistics.md).

# Order Profit Statistics

Calculate the total profit amount for each year based on order data.

## Sample Data

![](/files/MQGxLKkbQIEcYwTd4Nal)

## Prompt

> Help me calculate from the order table, how much profit each Customer made in 2014, 2015, and 2016 respectively.

## Excel Cursor Response

![](/files/lS0VJnefJ5kz1jRu3xv4)

## Result

![](/files/lBT0pKy17znrEQCcVsSU)