How would I sum up values depending on a value in a related cell?
I want to be able to add and change the values in columns A and B and have the amounts appear (and sum, if for the same Age) in the right row in column F:
Some kind of array formula with COUNTIF?
SUMIF will do that, if you already use Countif then SUMIF will be easy to use
@Drakien started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
How would I sum up values depending on a value in a related cell?
I want to be able to add and change the values in columns A and B and have the amounts appear (and sum, if for the same Age) in the right row in column F:
Some kind of array formula with COUNTIF?