Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread Display Modes
Old Jan 6, 2013, 11:07 PM   #1
macrumors newbie
Join Date: Jan 2013
IF/THEN statements in numbers

Hello all,

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.

BrandonIrby is offline   0 Reply With Quote
Old Jan 7, 2013, 10:04 AM   #2
macrumors 6502
Join Date: Dec 2011
Location: Winnipeg
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, Intel 520 240GB SSD
 11" 2012 MacBook Air, 1.7 GHz i5 Duo, 4GB, 128GB
 4th. Gen. iPad, 16GB, WiFi  4th. Gen. TC, 2GB
prisstratton is offline   0 Reply With Quote

MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
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

Forum Jump

All times are GMT -5. The time now is 10:49 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2015, MacRumors.com, LLC