I just want to know if there is any way (formula) to count the numbers all the cells which are not empty in a column or row disregarding the content of the cell.
It may contain date, text or even number. I don't want to have the sum of those numbers, rather how many cells, have something in them.
I'm new to iworks and have trying to figure this one out for a while. I used a template to set up financial info and calculate how much was spent on items. This was the preset formula: =SUMIF(Transactions :: $Category,A2,Transactions :: Amount)
However, I only want the sum from a particular range of dates (e.g. 9/1/09 to 9/30/09, as in cells B2:B10) so I can budget accordingly. In excel, you just grab the highlighted corner and drag it to where you want- here I can't do that and it won't let me add any more "conditions". Any idea how to remedy this? It's driving me nuts. On a side note, I am NOT a programmer so programming language will unfortunately not help unless you get VERY specific about how to do it (which you probably don't want to do).
In Numbers '08, is it possible to link cells/columns between sheets; so that in the below spreadsheet selecting an item from Column A in "Hub Dimensions" sheet in the drop down box of the "Spoke Calculator" sheet would fill out the cells in Column D of the "Spoke Calculator" sheet with data from the related cells in the "Hub Dimensions" sheet?
HiThe usual tale of an Applescript beginner getting lost but, I want to be able to search for a selected membership number within a Numbers spreadsheet, extract that member’s email address and send a message. I have managed to create a script that creates and sends the email but after several attempts I cannot work out how to start searching cells for a particular value and how to extract data from cells in the selected row.
Every time I change the cell format in numbers, it keeps going back to 12/30/11 when I want 2/1/12. It is quite frustrating because I did what it said to do.
The v_products_url_1 column is blank, but it contains information from the previous column. Is there any way to not have the previous cell overlap the empty one?
Can I merge multiple files, and multiple file types, into a single PDF with my MacBook Pro?, Can I merger multiple files, and multiple file types, into a single PDF with my MacBook Pro?Â
I need to combine word docs, .jpgs, .PDFs, .pptx files from multiple sources into a single PDF. In the past I've used software such as Nuance but I'm wondering if there's something in the MacBook Pro OS or applications that support this function.Â
Does anyone know why copying borders from one cell to another in Numbers doesn't work? It's pretty inefficient creating borders for each cell all over the place.
I'm creating a Service in Automator, and would like incorporate an Apple script that will "cut" the first word in any Numbers cell that I select, and "paste" it into the cell directly to the left of the the cell I've selected. Let's assume the column I'm selecting from is Column C. As a very rough start, here is what I have (with some of things I'm trying to accomplish in brackets): on run {input, parameters} try set MyText to input as string set FirstWord to first word of MyText set [remove the first word and a single space from what I've selected]tell application "Numbers"tell table 1 of sheet 1 of document 1 set theRow to [the row of the cell I've selected] set value of cell 3 of theRow to FirstWord end tellend tell end try return inputend run.
I have multiples files (type PDF) that is mostly singled page and want to "combine" or "merge" into one file that contains all the single PDF file. Instead of opening up and drag-move one at a time, is there a quicker, efficient way?
I transferred my old mac to a new mac using migration assistant and it created another user account on the new machine. Is there a way to merge the two accounts into one on the new machine?
I figure I'm not the only one who is going through this, but I am hoping there is a way to merge my iTunes account purchases into 1 account. When I was single I had my personal account and bought music, tv shows, & movies under that iTunes ID. At the same time my future wife was doing the same. Now that we are married and have multiple devices including an iPhone, iPad, & Apple TV I'm looking for a way to merge each of our "pre-relationship", personal purchases into our family account.
I already made the "family" iTunes account that all of our devices use, allowing all store purchases from here-on-out to be able to be utilized on all devices. iTunes Match has helped in the music department because I downloaded all of our music from all account onto my computer and uploaded them to iTunes Match, thus making one large stock pile of collaborated account music which is able to be heard on any device linked to our iTunes Match account.
The problem I'm running into is that there isn't a similar option for TV shows & Movies. Right now they are downloadable from iCloud but only when logged in under the particular account. I have downloaded them all onto my Mac but I can't transfer them to my devices unless I plug them into the Mac or I "Home Share" to my Apple TV. Is there a way for me to open my Apple TV, iPhone, or iPad under my family account and be able to access purchases from our other accounts.
In order to get more run time out of door, the better way is using high capacity battery. Some ask me if we can use 12 cells Mac Pro battery to replace 6 cells battery.
I've been ripping my hair out trying to find the answer to this.
In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.
For example:
Column A - 1 - 5
Column B - (value in Column A * 5)
I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.
The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"
See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.
like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.
I am in India with a cell phone that has an unlimited data plan and legally allows tethering and has blue tooth. I am trying to connect to the Internet through the cell phone using blue tooth to my Macbook. I can "pair" with the cell phone but cannot connect. My new Macbook is running Snow Leopard
I can see the Nokia 7210 by clicking on the bluetooth icon upper right on the Mac. I can see the Macbook in the cellphone and click on connect in the cell phone.
Then the cell phone says "connecting to Macbook" followed by "service not supported by other device".
I have clicked on every combination I can find in blue tooth preferences on the Mac but can't get it to connect. Under blue tooth in the Mac it says paired but not connected.
Sometimes the Mac asks for a user name and pass code for the cell phone and it also asks for APN whatever that is. The owner of this cell phone tells me there isn't any username or passcode necessary and he has successfully connected through Windows notebooks without so using.
I have a mytouch 4g cell phone with adapter cable, that use to be working just fine with my macbook pro. The cell phone icon would show up on my screen, and I could transfer pictures from there.  Out of the blue, the icon for my phone is no longer showing up on the screen , therefore, I can no longer access pictures and tranfer them to my computer anymore.Â
I'm using a Macbook pro OSX 10.4 Tiger, and have been experiencing a very bizarre, spooky, specter-like occurrence happening as of late when I watch streaming videos off common site such as Hulu. I'm using the newest version of Firefox and my roommates and I have wireless internet with various routers rigged sort of haphazardly throughout the apartment. Sometimes whenever my cellphone alarm goes off, or an incoming call comes in, the ringtone will come through the speakers of my computer! This takes place even if I'm on a different floor or in another room. It has even happened when my cellphone is put to silent! Can anyone explain or speculate why this is happening? It always freaks me out, and won't go away unless I close the video or browser.