Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel help
Using excel 2000, is there a formula to calculate a range?
|
#2
|
|||
|
|||
deb, =SUM(A1:A100) ??? post back with more information if that is not it
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "deb" wrote in message ... Using excel 2000, is there a formula to calculate a range? |
#3
|
|||
|
|||
The "sumif" formula will calculate a range for you.
Example: SUM(IF('Report Data'!$D$3:$D$3000="r17",'Report Data'!$P$3:$P$3000,0)) In the above formula, all values in the "P" column in my "Report Data" worksheet will be added together if they there is a corresponding value in the "D" column Or if you have no qualifying criteria, just using the auto sum and then highlighting all the cells you want to calculate. Hope this helps. -- red_wave "deb" wrote: Using excel 2000, is there a formula to calculate a range? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |