There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot bsod computer connection cpu crash css dell desktop dma driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware hijackthis hjt install internet internet explorer itunes keyboard laptop macro malware monitor motherboard network networking outlook outlook 2003 outlook 2007 outlook express pio problem problems router seo server slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp winxp wireless
Business Applications
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: Need help with a formula in Excel please


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
baldrod's Avatar
Member with 37 posts.
 
Join Date: Oct 2005
Experience: Intermediate
17-Jul-2008, 10:13 PM #1
Solved: Need help with a formula in Excel please
Can anyone help me figure this out? I am running out of time for a dead line and this is the last stumbling box I have.
I have 16 rows and at the end of each row is a total in the last row is the bottom of the column that totals the rows above it. If any of the 16 rows are <40 I want it to total them in the bottom row if they are >40 I dont want a total in the bottom row and I would like it to highlight the box if there is a sum in the bottom row and not highlight if it is empty.

I am using Office 2007
User3's Avatar
Junior Member with 3 posts.
 
Join Date: Jul 2008
18-Jul-2008, 01:07 AM #2
good microsoft
I am using office 2003. I can get more help this site. the end of each row is a total in the last row is the bottom of the column that totals the rows above it. If any of the 16 rows are <40 I want it to total them in the bottom row if they are >40 I dont want a total in the bottom
Aj_old's Avatar
Computer Specs
Senior Member with 604 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
18-Jul-2008, 01:30 AM #3
If you wanna to sum all cells that have value grater than or equal to 40 then write this:
Code:
A17=SUMIF(A1:A16,">=40")
If you wanna to sum if in the columns is at least one value less than 40, then write this:
Code:
B17=IF(COUNTIF(B1:B16,"<40")>=1,SUM(B1:B16),"")

To highlight cells in row 17, that have sum in it, select the row 17, go to Format\Conditional formating, select "Cell Value is", "not equal to", and type "="""
__________________
The BestS
AJ
baldrod's Avatar
Member with 37 posts.
 
Join Date: Oct 2005
Experience: Intermediate
18-Jul-2008, 02:40 PM #4
Thanks so much for the help I always know where to go when the going gets tough
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 11:04 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.