# \#summary-field

**URL:** https://the.fmsoup.org/tag/summary-field/545.md

[Latest](https://the.fmsoup.org/latest.md) · [Categories](https://the.fmsoup.org/categories.md) · [Tags](https://the.fmsoup.org/tags.md)

---

## [Searching on summary fields](https://the.fmsoup.org/t/searching-on-summary-fields/5348)

<div class="topic-metadata">

**Author:** [@cpking](https://the.fmsoup.org/u/cpking)\
**Replies:** 3\
**Last updated:** [March 31, 2026, 2:24pm UTC](https://the.fmsoup.org/t/searching-on-summary-fields/5348 "2026-03-31T14:24:32Z")

</div>

Scenario: Two tables. 1) Main table with product ID and details; 2) related table with orders of Product ID. Relationship is one-to many, similar to invoices. I create a summary field (Number of Orders) in the related t…

---

## [Sumifs equivalent](https://the.fmsoup.org/t/sumifs-equivalent/2441)

<div class="topic-metadata">

**Author:** [@cpking](https://the.fmsoup.org/u/cpking)\
**Replies:** 8\
**Last updated:** [September 9, 2021, 9:12pm UTC](https://the.fmsoup.org/t/sumifs-equivalent/2441 "2021-09-09T21:12:42Z")

</div>

I'm back trying to essentially cross-tab some data. I have a solution with multiple related tables. A songbook table which includes a song title, duration, etc. A gig table which includes information like performance …