Can I create a new column where all values in a column associated with a particular date in 2nd column are summed?

Question

feel as if this should be possible with a conditional formula but I am not managing to get what I want to happen....possibly very easy for someone used to using formulas!

Byron_JMP · Accepted Answer

take a look at the Col Sum() function

You can put your column to sum in the first argument, followed by the column you want to sum by

col sum(:Qty, :Date) or something like that.    Date might need to be nominal.

Col Sum(name,<By var, ...>)

Description

Calculates the sum across rows in a column. Calculating all missing values (Col Sum(.,.)) returns missing. The result is internally cached to speed up multiple evaluations.

Returns

The sum.

Argument

name A column name.
By var (Optional) A By variable to compute statistics across groups of rows. Use the By

variable in a column formula or in a For Each Row() function.