Cell ranges and IF statements
Hi,
My column G has lines G2:G100 which have a equation each that check to see if column F is checked. If column F is checked than it calculates a price. In cell J3 I want the total of G2 to G100 unless the fields are blank. In that case I want cell J3 to read 0. J3 and column G are both formated with currency.
Any help apreciated.
stefan82,
Welcome to the forum!
Sum should accomplish that by itself:
=SUM(G2:G100)
If that is not yielding the results you've described, please upload some sample data showing the problem.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
The equation is for the cells in G2. The equation is good but I need to add a way to put in 0 if the G column is blank.
The problem is in cell J3. What is that formula?
Last edited by tigeravatar; 04-24-2012 at 06:55 PM.
stefan82,
Attached is an example workbook based on the picture you posted. I am unable to reproduce the error you're showing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks