Help with a formula to return a zero

prihia971 · #1 10-06-2016, 01:23 AM

Hi,

I'm new to excel.

I have a range AG:AJ.
Within this range there are numbers
0.25,0.50,0.75,0.00

In cell AK I have the following formula
=IF(SUM(AG12:AJ12),SUM(AG12:AJ12),"")

sometimes there might on be 0.00 within that range. I'm wanting to ensure that total (0.00) shows in cell AK and if there are no values in range AG:AJ, to leave AK blank.

Any suggestions?

xor · #2 10-06-2016, 02:17 AM

Let me see if I understand:

1 or more values i AG12:AJ12 < 0 or > 0 (1, 2 or 3 can be blank) ----> =SUM(AG12:AJ12)
All values in AG12:AJ12 = 0 ----> 0
All values in AG12:AJ12 blank ----> blank

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need a formula (possibly something like VLOOKUP) that will return multiple results.	SilverUnicorn79	Excel	8	08-16-2016 01:34 PM
Formula to return next non-blank cell in a range	Anyroad	Excel	4	09-15-2015 04:13 PM
Formula to return a date	caz46	Excel	3	04-15-2015 08:59 AM
MS Excel Investing Formula for calculating stock return HELP pls	doug6388	Excel	0	09-05-2014 08:48 PM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM