9 Replies Latest reply: Apr 2, 2014 6:25 PM by Bmachine
Bmachine Level 1 Level 1 (0 points)

Hello esteemed Numbers community.

 

After searching long and hard for a simple job cost and invoicing system that would fit my needs, I have decided to do it myself in Numbers.

 

For the most part it is fairly straight forward but I have two questions.  THe second one will be in a separate thread so as to keep things organized.

 

I imagine this first one is a common request.  But it is hard to search for because of too many words...

 

Say I have my invoice amounts in column A.  And Column B is Payment received (Y or N).  At the bottom of column B,  I want to do a total of only the payments received.  In other words, something that does Total of all the amounts in column A but only IF column B has a Yes in it.

 

Thank you very much for any help.

 

Bo


Aperture 3, OS X Mountain Lion (10.8.2)