|Jan 6, 2013, 11:07 PM||#1|
IF/THEN statements in numbers
I am attempting to make a template spreadsheet in numbers to automatically calculate and SUM revenues from different cities in my service area.
City in which job was in -column A
Job revenue in- column B
Total revenues by city in- row 30
Formula in cell F:30
=IF column A contains 'city a' then SUM amount in 'column B'
I do understand this is not a valid formula, I am attempting to relay the desired effect.
Any help will be much appreciated.
|Jan 7, 2013, 10:04 AM||#2|
I do not use Numbers, but in Excel I would use the SUMIF() function.
Check this thread and my response/example:
17" 2011 MacBook Pro, 2.3 GHz i7 Quad, 16GB DDR3, Intel 520 240GB SSD
11" 2012 MacBook Air, 1.7 GHz i5 Duo, 4GB, 128GB
4th. Gen. iPad, 16GB, WiFi 4th. Gen. TC, 2GB
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|Watch your credit card statements!||Michael73||Mac Pro||0||Apr 15, 2014 02:55 PM|
|Mac Numbers question, can I put two IF statements together?||carmidy||Mac Basics and Help||1||May 21, 2013 08:29 PM|
|Geektool: If Statements||itsme932||UI Customization||1||Nov 28, 2012 11:47 PM|
|If Statements||eForce||iPhone/iPad Programming||8||Oct 21, 2012 02:02 PM|
All times are GMT -5. The time now is 12:48 AM.