how do you add-u cells value the othes is based another celll be

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Quantity Column. Based on if the Column is 1 or (-1) I do or do not
count the field for my total. if -1 count it with my negatives. if qyuantity
is +1 or higher then add the value of row H2:H00 to iu
 
sparkie said:
I have a Quantity Column. Based on if the Column is 1 or (-1) I do or do not
count the field for my total. if -1 count it with my negatives. if qyuantity
is +1 or higher then add the value of row H2:H00 to iu
Click to expand...

H2:H00? .. to iu?
I hope this helps:
Assume Quantity in column A; Amount in column B, In C, put:
=IF(A2 > 0, A2 * B2, 0)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
increment cell value based on another cell's value 1
My Never ending ARRAY code problems 18
For-Next by a row Counting consecutive Zero in the column 4
When found add it to the last and display total in Msgbox 23
Changing Cell Color based upon value on another worksheet 2
Hide rows of one sheet based on values in another sheet? 3
CountIf with And 0

Back
Top