Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Sum total of number based on color of field towards the left

Topic Labels: Formulas
400 3
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I write a formula to add total based on the colour of field/column towards the left? e.g in this table I want to add all payments labelled cash and sum in field 7. 7b9f7eea14dc89e250064aa1e6c74b360b140cc2.png

3 Replies 3

You can’t sum them in Field 7, but you can group your records by Type, and then use the summary bar to view the Sum.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

Welcome to the community, @yousaf_saleem! :grinning_face_with_big_eyes: One possible way to rethink your setup is to convert your {Type} field into a link to another table. On that table, you can roll up and sum all values for each type. Will that work?

if I want to sum total for only a certain date how I will do that?