|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
|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:41 AM.