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

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 7, 2013, 12:07 AM   #1
BrandonIrby
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


Ex.

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.

Thanks,
Brandon
BrandonIrby is offline   0 Reply With Quote
Old Jan 7, 2013, 11:04 AM   #2
prisstratton
macrumors regular
 
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:

http://forums.macrumors.com/showthread.php?t=1493249
__________________
 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
prisstratton is offline   0 Reply With Quote

Reply
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 03:55 PM
Mac Numbers question, can I put two IF statements together? carmidy Mac Basics and Help 1 May 21, 2013 09:29 PM
Geektool: If Statements itsme932 UI Customization 1 Nov 29, 2012 12:47 AM
If Statements eForce iPhone/iPad Programming 8 Oct 21, 2012 03:02 PM

Forum Jump

All times are GMT -5. The time now is 11:07 AM.

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

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