How do I times Rate row by Async row in one formula to get total number of each rate

msal

msal

So pretty much a formula that will give me 278.7

Thanks

Adrian Mandile CHESS

Hi @msal,

Are you able to insert a summary row above all your data? If so,

Add a new column to the right of Async and enter a formula in it of:

=Rate@row * Async@row

Add a new row above the first Rate row.

Indent all the data rows below the newly inserted row, to make it a 'Parent' row

In the cell of the parent row of the new column, add the formula:

=SUM(CHILDREN())

This will add all calculated products of Rate*Async below it.