formulas in numbers 09

by AppleBytes - 8/1/10 12:38 AM

In Reply to: formulas in number 09 by ajbwalk

Let's say cell B5 will be your totals
then put this in b5
=IF(C5="Word",B2+B3+B4,"")

Then using the numbers inspector to create a pop-up menu in cell C5, which contains two items. A blank item and your specific Word. Or make your specific word cell to populate however you want. B5 will add value once C5 is equal to your specific word.