Members Login
Username 
 
Password 
    Remember Me  
Freeze-Frame Radio -> Freeze-Frame Radio Lounge -> Any Excel experts out there?
Post Info TOPIC: Any Excel experts out there?
MzHartz


Permanent Vacation



Status: Offline
Posts: 23086
Date:
Any Excel experts out there?
Permalink  

Does anyone want to be my support desk for a second?

I've got an Excel file, and I want it to count the total of each organ, so I'm using the COUNTIF function. It appeared to be working right, but when I add all the totals together, it comes out larger than the number of rows in my sheet!

Has anyone had a problem like this before? Have you ever solved it?

__________________

tumblr_maefr2j2Bt1rrd8d6o1_500.gif

 
MzHartz


Permanent Vacation



Status: Offline
Posts: 23086
Date:
Permalink  

I think my brain is still on Thanksgiving break. I was counting the same organ twice! I'm not having a good day....

__________________

tumblr_maefr2j2Bt1rrd8d6o1_500.gif

 
confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  

I am glad that you worked your issue out Mz. It does sound a little strange that you are counting organs though.

__________________

Stop trying to be what you see. Be what you ought to be.
Ultimo


King of the Ring

Status: Offline
Posts: 4941
Date:
Permalink  



__________________

Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

She works with organ transplant patients, so I'm assuming she was working with the statistics on the most popular transplants, possibly related to the cost of transplant.

Last night she was complaining about how the count was still two off, but she eventually gave up on it.

__________________
JD The Jazz Doctor


Grand Poobah

    



Status: Offline
Posts: 36897
Date:
Permalink  

I would say that I am an Excel unexpert. And while at it, do you suppose the Access folks were laid off around the Office XP era?

__________________
"And like Web, I enjoy throwing JR under the bus.  Problem is, it's usually under the special bus that I ride every day". Ghostdancer 12-18-09
Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

Access is evil and should have never been created.

__________________
confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  

I agree. Access sucks. But I suppose until someone comes up with something better, we are stuck.

__________________

Stop trying to be what you see. Be what you ought to be.
Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

Mz was complaining last night about Access at her job. Apparently they are merging their Access database with another, better database they have, and they're going to have to deal with all sorts of problems.

__________________
confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  

As if Mz needs that aggravation too. I hope she is able to hold onto her sanity.

__________________

Stop trying to be what you see. Be what you ought to be.
Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

She's going through a lot this week, so I hope so too!

__________________
confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  

I hope she has plenty of wine at home.



__________________

Stop trying to be what you see. Be what you ought to be.
Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

Trust me, she does!

__________________
WebGuy


Doesn't Do Windows



Status: Offline
Posts: 25589
Date:
Permalink  


When I got this laptop new, It came with a copy of the Lotus suite. Actually, way back toward the back of the manual, there was page with a free coupon to order the software. When I called to order it, I asked why the coupon was way in the back like that. She said that that is the reward for the few that actually read the manual.

Since I have it, I use Lotus Approach here for my customer database. I've not had any trouble with getting it to do what I needed. I tried playing with Access ONCE and that was enough.

It really amazes me how many people assume that everyone has Micro$oft Office when they send files. I use openoffice.org to work with those files when necessary.



__________________


Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

Will openoffice.org work with Works files too? I get people sending me Works documents all the time that I can't open, and I always tell them to send them as RTFs.

Personally, if I have to send someone a file, it's a PDF.

__________________
WebGuy


Doesn't Do Windows



Status: Offline
Posts: 25589
Date:
Permalink  


Hmm, I'm not sure if it will read Works files.

I'm looking at the home page now and it stresses Word but I'm not finding anything about Works.

It's a freed download if you wanted to try it. openoffice.org



__________________


Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

Hm, it looks like it might. I'll download it, it's worth a try.

__________________
WebGuy


Doesn't Do Windows



Status: Offline
Posts: 25589
Date:
Permalink  


Cool, let me know if it works.

This is shocking, but I've heard that Microsoft is going to move toward the open XML style of file types with Office. Maybe they are finally seeing the benefit of trying to work with the rest of the world and join some "standards" rather than "our way or no way". I think they are starting to realize that their "all Microsoft or nothing" approach to software is going to bite them in the butt with people getting fed up and moving to Linux and other open source software.



__________________


Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
Freeze-Frame Radio -> Freeze-Frame Radio Lounge -> Any Excel experts out there?
Tweet this page Post to Digg Post to Del.icio.us


Create your own FREE Forum
Report Abuse 		Powered by ActiveBoard