PDA

View Full Version : Summing data



Alasbabylon
03-13-2008, 09:00 AM
I have a large number of spreadsheets to work today. They have long columns of time data, One column lists hours, one column designates each row as a 1, 2, 3, or 4. I need to check column 3 throughout worksheet, and add all values in column 2 that have a column 3 designation of 1, then divide the total by 60 to get the average. I need to get the total of corresponding vaues for 2, 3, and 4 as well. So I need some sort of IF Then maybe? I'm on a tight timeline and have very little VBA knowlwdge. I can record macros, but am not very good at programming them. Anyone have a suggestion?

Bob Phillips
03-13-2008, 09:09 AM
=SUMIF('Data Sample'!$C:$C,1,'Data Sample'!$B:$B)/60

etc.

Alasbabylon
03-13-2008, 09:49 AM
When I use this formula, I get the right response: =SUMIF(C[-2],1,C[-3]).
Two questions: Why am I getting this notation for the cells? And when I move this to the actual file, where I have over 60,000 rows of data, I get an answer of 0. What am I doing wrong? (In the actual file, the columns I am referring to are 13 and 12, but they show up as =SUMIF(C[-2],1,C[-3])/60

Bob Phillips
03-13-2008, 09:52 AM
When I use this formula, I get the right response: =SUMIF(C[-2],1,C[-3]).
Two questions: Why am I getting this notation for the cells? And when I move this to the actual file, where I have over 60,000 rows of data, I get an answer of 0. What am I doing wrong? (In the actual file, the columns I am referring to are 13 and 12, but they show up as =SUMIF(C[-2],1,C[-3])/60

I have no idea what you are saying.