topic Re: how do I use a formula that subtracts Col B from Col A and divides by Col C but on a per month basis in Discussions

how do I use a formula that subtracts Col B from Col A and divides by Col C but on a per month basis

fionaweston — Sat, 10 Jun 2023 23:28:24 GMT

I have 3 months of data in my file, Jan, Feb and Mar.

I'm using this formula

(Col Sum( :A ) - Col Sum( :B )) / Col Sum( :C )

But I need the value per month.

Thanks

ms — Thu, 08 Apr 2021 19:41:51 GMT

Most Col Stat() functions support optional by-variables.

This formula, where :Month is the by-variable, give monthly values (repeated in every row of each month)

(Col Sum( :A, :Month ) - Col Sum( :B, :Month )) / Col Sum( :C, :Month )

fionaweston — Thu, 08 Apr 2021 19:59:47 GMT

Perfect, thanks!