Intel Mac :: Write A Formula To Add Selected Cells?
Mar 25, 2012How do I write a formula to add selected cells?
Info:
iMac
ADVERTISEMENT
Applications :: Numbers - Formula Not Let To Select Cells - Only Whole Column
Oct 17, 2009I'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).
MacBook Air :: How To Write Math Formula On Pages
Apr 5, 2012How to write math formula with Pages ?
Info:
MacBook Air, Mac OS X (10.7.3)
Intel Mac :: Make Text Cells On A 45 Degree Angle?
Jun 21, 2012I am trying to make a chart and I am trying to make the top row of colums with the information postioned on a 45 degree. How do adjust the setting in numbers or pages to accomplish this.
Info:iMac, Mac OS X (10.7.2)
Intel Mac :: Cannot Boot From Selected External Drive On Intel Core Duo 10.4.3?
May 29, 2012OS X 10.4.3 IMAC Intel Core Duo. I backed up my HD on an external drive so I could upgrade to Snow Leopard. I wanted to test that I could boot from the external drive and selected it as my start up drive. When I did a restart I got the Apple and the turning gear and then suddenly a black screen with this on it:
"May 28 22:23:11 Launched:com.apple.nibindd:respawning too quickly throttling, exited system abnormally bad system call too many failures in succession I have no name!"
I tried several dozen times with no luck. I think when I made the copy of my HD on the external HD I may have neglected to make it "bootable" (moving too quickly). My internal CDROM is busted so I use an external CDROM. I can't boot from it at all with the proper start up buttons pushed. It keeps trying to boot from the external drive. If I turn the external drive off and try to boot from the external CD I just get the grey file with the ? in the middle of it.
I tried using another external HD I have with OS 10.4 on it, but it won't recognize it either with fan, alt, shift, delete pressed at start up. My internal drive (a Seagate 2 tarabite drive) works great, but how do I reset it as the start up drive when I'm stuck with this black screen. One more thing, when I try to reset PRAM I don't get a second gong.
Info:
iMac Intel Core Duo 2GHz 17", 2006 model
Mac Pro :: Can We Use 12 Cells PRO Battery To Replace 6 Cells Battery
Apr 14, 2010In 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.
View 1 Replies View RelatedIntel Mac :: Restoring Selected Files From Backup?
Jul 1, 2012I am organizing all my pictures fro1999 to the present. Some exist only in backup files. Is it possible to restor only picture files (not the complete backup) from older backup files from my earlier iMac
Info:
iMac, Mac OS X (10.7.2)
Intel Mac :: Deleting Selected Songs From My Library Are Still In IPod?
Apr 3, 2012ive tried deleting selected songs from my library and they delete but when i check my i pod they are still on where am i going wrong???
View 1 Replies View RelatedOS X :: Unable To Write External Hard Disk In Mac / Can Read Write In Windows
Feb 15, 2011i had a External Harddrive.Currently i can Read//Write on it in Windows PC(Windows7)But when i use the same drive in Mac i can only read...but can't able to write. How to resolve this issue
Intel Mac :: Using Bootcamp Want To Write / Delete Between Each Partition
Apr 5, 20122011 iMac, Lion 10.7.3 Using bootcamp, I add windows partition(NTFS) so, my HDD has two partitions now.What I want to do is.Running OS X, write and delete files on Windosw partition and running Windows, write and delete files on OS X partition Possible?
Info:
iMac, Mac OS X (10.7.3)
Intel Mac :: Write To Ntsf Hard Drive From Lion?
Feb 12, 2012What do I need to be able to write to a NTSF external hard drive from my IMAC using 10.7.3 Lion.
Info:
Airport express, Mac OS X (10.7.3), writeing to ntsf ext hard drive
Intel Mac :: Performance Down After Enabling Read / Write For Portable HD
Apr 8, 2012I tried enabling read/write for a portable HD by following an online Youtube using sudo nano /etc/fstab. Now my system is VERY slow....what can I do to revert this. I have already removed the command in the FSTAB console. BTW I still cannot write on the HD. I am using OS 10.7.3 Intel 2.4GHz Core2Duo iMac 4GB RAM.
View 3 Replies View RelatedIntel Mac :: Photo Editing That Allow To Write Captions On Pictures?
May 25, 2012I have only had an imac for 3 weeks would like to know of a simple photo editing program that will enable me to write captions on a photo.
View 2 Replies View RelatedIntel Mac :: How To Get Hard Drive To Read / Write Faster
Jun 21, 2012I just had the hard drive replaced in my IMac and it only at 1 to 1 or maybe 2 to 1 speed. my old one did over 10 to 1. car it be speeded up? Any way to get hard drive to read/ write faster?
Info:
iMac, Mac OS X (10.7.4)
Intel Mac :: Internal DVD Burner Failed To Write Sense Code 0x02
Mar 30, 2012iMacrunning OS10.7.3 have been burning DVD sucsessfully Using Toast 11, but now receive error message Sense Key = Medium error sense Code 0x02 No seek complete. Tried different blank DVD's same error. What does the Code mean?
Info:
iMac, Mac OS X (10.7.3)
IMac (Intel) :: Can't Write On External HD - Status Changed To NTFS Format
Aug 30, 2014Some time ago I had a problem with my iMac. Turned out my internal HD was broken so I got a new one.
The problem is that after I got my iMac with the new INTERNAL HD back, I was unable to write data on my EXTERNAL (Toshiba) HD, which until then I had no problems with. When I checked the format of it, it now says NTFS.
As I have more than 1 TB of data on it which would take forever to back up, is there another way to change it's status and write on it again? I was once able to do it, so I don't know where the problem is.....
Info:
iMac, OS X Mavericks (10.9.4)
Applications :: Unable To Use Numbers Formula
Mar 14, 2009I'm trying to create a template for legal billing. The only thing I'm really having a problem with is the formula that multiplies time by hourly rate. The time spent cells are formatted to show it as 4h 5m ... and that totals perfectly with the SUM formula. When I multiply it with a rate cell formatted to currency the math is fine, but the format stays as 00h 00m ... even when I format that cell to currency.
Applications :: Finding Mac Numbers Formula
May 27, 2009I want to set up a cell that has a number in it. That number is to decrease by one every seven days is there a formula that I can use to do this automatically
View 2 Replies View RelatedApplications :: Using Excel Formula In Numbers
Feb 22, 2010I am a newly converted Mac user and have some entrenched Excel habits, and try as I might, I couldn't locate this Excel formula in Numbers.
In Excel, I use "=C55 (or cell reference)" to copy that particular value from one worksheet to another.
I do this by clicking on the cell where I want the value to be copied to, type = and then switch to the other worksheet and click on the cell I want to copy. And voila, I am now back onto my 1st worksheet with the value showing. I do this because the value I want to copy to this cell changes regularly.
Numbers :: Formula To Budget On A Per Pay Period
May 3, 2010I am creating a new budget sheet, and am trying to automate it as much as possible. I get paid bi-weekly, and I like to budget on a per pay period case rather than month to month. What this means is that on certain budgets I have one set of bills due, on another I'll have a different set of bills due.
View 5 Replies View RelatedIMac (Intel) :: Startup Disk Could Not Gather Enough Information On Selected Disk
Jul 1, 2014Every time I try to restart my computer on my Hard Drive I get this message "Startup disk could not gather enough information on the selected disk". As of right now I am running my whole computer off of a 16GB flash drive that is quickly running out of memory. How do I fix my Hard Drive without losing all 150GB worth of data. I am running off of OS X 10.6.8 and have another iMac that is working fine.
View 2 Replies View RelatedIMac (Intel) :: Trash Keeping Many Multiple Copies Of Mail Messages When Write Them?
Jun 22, 2014why does my trash keep many multiple copies of mail messages as I write them.
View 2 Replies View RelatedApplications :: Numbers - Formula For Scheduling A Timetable
Oct 14, 2010I am studying, there is a weekly timetable made of 20 individual classes, each on 4 times a week. I would like to know how to make a spreadsheet so I can manually input all these classes and have it return a non conflicting pattern. By that I mean that I want a personal timetable that will let me visit each class at least once a week.
View 1 Replies View RelatedApplications :: Excel 2008 Date Formula ?
Feb 28, 2009I have a very limited knowledge of Excel, but generally find that I can figure things out eventually. However, this time, I just can't seem to tweek it so the result is what I want.
I have a spreadsheet for tracking parts ordered, and simply need to display how many days a part has been on order. I have a column for date ordered, and one for date received. Is there a way to program the formula to tell me the days that a part has been on order without displaying today's date in the spreadsheet (leaving it blank), and still be able to enter the date that it does arrive for our records?
Applications :: Excel To Numbers - Fx Formula Not Compatible
Jan 25, 2010I have recently run a 13 page excel spread sheet for a budget on Windows and on transferring it to Numbers on my new mac, one of the formulas is not compatable. this is what I do. There is a balance figure on each of pages 2 to 13 which are then required to be transferred as a total figure in one of the columns on page 1.
This was the formula on windows: =SUM(xmas:Savings!F2)
Applications :: Numbers - Formula To Calculate Pay Per Hour / Day
Mar 23, 2010I'm an independent contractor and keep track of my hours worked & amount paid for the year in numbers, and thus far its working Great! However, I'm attempting to figure out how much my "pay per hour, per day" is, and need am wondering if there is an easier way to do this.
My spreadsheet is setup like the following:
Rows = Days worked
Column F = Time worked
Column G = Amount paid.
So to figure out how much I made "per hour per day", I simply take Column G divided by Column F for each day. However, I'm currently manually entering this script into each row, and given that I worked over 200 days last year(i.e. I manually enter in row 1 =SUM(G1)/(F1); row 2 =SUM(G2)/(F2), etc.
Is there an easier way to do this? Is there a way to sequentially apply scripts, so instead of manually entering G2/F2, it will automatically apply the =Sum G / F's of that row? I'm on numbers 08
Applications :: IWork Numbers - Formula With Category
Aug 14, 2010I have a list of expenses and there are columns such as "Description, Cost" the usual, but I also made one named "Type" that is populated with either "Business, Personal," or "Fixed Expenditures".
I would like, then, to make another table that links to the first with three rows. Each one adds the total cost of Business, Personal, and Fixed Expenditures. How can I accomplish this?
I want to divide the expenses into expenses types and create a sum for each type.
Basically, it categorizes the expenses and puts them in three different totals: one for each "Type" of expense.
Applications :: Numbers - How To Rename Cells
Sep 26, 2009In Excel, you can easily rename a cell to whatever you want. i.e from A1 to yaxis How do you do this in Numbers? I can't find it.
View 1 Replies View RelatedApplications :: Excel 2008 - Reset Formula Bar Position?
Mar 19, 2008The left edge of my excel formula bar is not showing-almost as if it was pushed off the left side of the desktop (see picture). Unfortunately, the only part of the formula bar that allows it to move is now hidden, so I can no longer move the formula bar. I have tried switching the formula bar on and of in "View" and also tried re-loading excel, but it is stuck. Does anybody know how to reset the formula bar position?
View 6 Replies View RelatedApplications :: Excel 08 Formula Builder With Multiple Worksheets
Apr 3, 2009I am currently using excel 08 and have made a workbook with multiple worksheets in it. Each worksheet contains information on multiple products, such as description, UPC, cost, retail, sale cost, sale retail, how many items sold during sale, etc. Sales are two weeks, so every two weeks, I add a new worksheet with new information for sales I will be running a few weeks down the road. I would like to see if there is a way that I can have excel look through the past worksheets so when I enter a UPC into the new worksheet, there would be a column at the end that would take the average items sold during past sales.
For example, if I want to put UPC 1234500000 on sale in the new worksheet, that excel would look at past times I had 1234500000 on sale and take the average of how many sold during past sales and enter that number in a cell on the new worksheet. I don't know if this is relevant or not, but Column D is where I enter UPC info, Column P is where I put how many sold, and Column Q is where I want this average sold to appear (no matter what worksheet).
