Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel Help

Comment:

I want to sum a column but I only want to use the value of a paticular row if a value in a another column same row exists such as a "Yes" or "X". Right now I am using the following equation: =SUM(IF(D8="",R8=0,R8),IF(D9="",R9=0,R9),IF(D10="",R10=0,R10),IF(D11="",R11=0,R11),IF(D12="",R12=0,R12))-1 This equation works some of the time depending if there are values in the entire column. I know this is a brute force method... Please be gentle Your time is Greatly Appreciated Scott

Name: A Certain TH
Date: September 23, 2005 at 03:42:32 Pacific

Reply:

Ooohh - you were so close! Look up the "SUMIF" function in help... Tom

0

Reply:

Hey Tom... You are the man!! That took care of it very cleanly and with little effort. Thanks for you time I really appreciate it Best Regards Scott

0

Access storing personal e...

Mail-merge & email

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Best advice I can give, as it's what I did when I started out. use the Excel Help as I found it very educational. I wrote an entire accounts package that way for a small company. Took three months to ...

Summary: Yes, check the Excel help on using macros to set font colors within rows/cells, and on highlighting rows. I am curious though. Why would you prefer that, rather than have the search take you to that c...

Summary: Excel Help!!! I have been trying write a macro to perform the following task: I have a number of differen spreadsheets in my work book for which i have created a summary sheet as well. I want to au...