Summary Table
I am having difficulty getting my mind around this to even begin. I need to summarize the Revenue for a project: The Revenue Date can be a single, or multiple dates, and the Revenue Amounts can vary...
Forum Discussion
What I am really looking for would be similar to sumif in Excel
Something like this =SUMIF($P10:$P15,S$9,$R10:$R15)
| P | Q | R | T | U |
| Jan | Feb | |||
| Jan | 1/2/2024 | $ 5.00 | 11 | 7 |
| Jan | 1/9/2024 | $ 6.00 | ||
| Feb | 2/2/2024 | $ 7.00 | ||
| Apr | 4/2/2024 | $ 8.00 | ||
| May | 5/2/2024 | $ 9.00 | ||
| Jun | 6/2/2024 | $ 10.00 |