formula for adding different coloured numbers
In a table containing numbers in 3 different colours, is there a formula for adding up, separately, all the numbers in each colour?
Thanks.
iMac, OS X Yosemite (10.10)
In a table containing numbers in 3 different colours, is there a formula for adding up, separately, all the numbers in each colour?
Thanks.
iMac, OS X Yosemite (10.10)
Hi Gyllylal,
Colour is a formatting attribute and can't be use in formulas.
You can use the SUMIF or SUMIFS functions to add values in a range.
Formula in Footer Row 12
=SUMIF(B,"<4",B)
Formula in Footer Row 13
=SUMIFS(B,B,">=4",B,"<7")
Formula in Footer Row 14
=SUMIF(B,">=7",B)
The rules in A12, A13 and A14 would be the same rules to use in Conditional Highlighting to set the colours.
Regards,
Ian.
Hi Gyllylal,
Colour is a formatting attribute and can't be use in formulas.
You can use the SUMIF or SUMIFS functions to add values in a range.
Formula in Footer Row 12
=SUMIF(B,"<4",B)
Formula in Footer Row 13
=SUMIFS(B,B,">=4",B,"<7")
Formula in Footer Row 14
=SUMIF(B,">=7",B)
The rules in A12, A13 and A14 would be the same rules to use in Conditional Highlighting to set the colours.
Regards,
Ian.
Thanks for this. I think I can adapt it to suit my purpose.
formula for adding different coloured numbers