Can I create a new column where all values in a column associated with a particular date in 2nd column are summed?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!
Data TableRe: Can I create a new column where all values in a column associated with a particular date in 2nd column are summed?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,)
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.
Re: Can I create a new column where all values in a column associated with a particular date in 2nd column are summed?great thanks - got that to work
