I am seeking assistance on how to capture the sum in one column based on the column of picklist?
Also, can date be added as a filter?
Example:
Column 1 is date
Column 2 is sale
Column 3 is picklist (item A, Item B)
Sum if = Item A
Sum if = Item B
Sum if = Item A sold in 2022
Sum if = Item A sold in 2023