Sum Select And Statement Help

[BlakeHammond]

HI All

Looking for a bit of guidance on this one.

I am trying to create a project total view that will show the overall project costs for new quotes.

For Ref I have tables called:

Equipment 1 - 6 - These all have separate total views for each table

using formula

sum(
Select(
Quote Sheet Equipment 1 [Total Equipment Cost],[Quote Key]=[_THISROW].[Quote Key]))

In each column

However, I need a statement that closer resembles

sum(
Select(
Quote Sheet Equipment 1 [Total Equipment Cost],[Quote Key]=[_THISROW].[Quote Key]))
and(
Quote Sheet Equipment 2 [Total Equipment Cost],[Quote Key]=[_THISROW].[Quote Key])))

I now the above expression isn’t correct but I’m sure you’ll get the gist of it.

I have tried adding a and statement but I can only get it to work if it an and on the [Quote Key]=[_THISROW].[Quote Key] Part.

Any help is appreciated.

Thanks

Blake

[Lynn · Accepted solution]

Hi @BlakeHammond
Maybe try SUM((SELECT… +SELECT(…

[BlakeHammond]

HAHAHAHAHA Why didn’t I think of that?

Thank you very much.

[Steve]

For reference:

help.appsheet.com

List Addition

Add lists together to produce another containing all items in the originals.