I need to get a sum from multiple 'IF' cells

Solved/Closed

Hmmm.... - Apr 13, 2010 at 09:05 PM
Hmmm.... - Apr 13, 2010 at 09:41 PM

I have a spreadsheet with the following formula:

=IF(ISNUMBER(E5), "20.00","")

If data is entered in cell E5, the cell below it will have 20.00. If not, the cell will be blank. This is the case for columns E, F, G, and H

At the end of the row, I am attempting to get the sum of all the cells in this row.

I did the standard sum formula, but it always comes up with 0 whether or not the cells have a value present. How can I produce a sum, if the IF formula is present?

Thanks!

I need to get a sum from multiple 'IF' cells
The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
Excel multiple lines in one cell - Guide
How to split excel sheet into multiple worksheets - Guide
Mpc hc multiple instances - Guide
How to delete cells in word - Guide

1 response

Answer 1 / 1

Hmmm....
Apr 13, 2010 at 09:41 PM

Figured it out. Changed the "20.00" to a cell location with the value 20.00 in it. That fixed it!

Similar discussions

Cannot download multiple files at once in WhatsApp Web

How to create two WhatsApp accounts on a Windows PC?

Clear cell contents based on value of another cell range using VBA

help me to add particular cells

Consolidate data from multiple sheets to one sheet.

Similar discussions

Subscribe To Our Newsletter!