Thread: how do you add-u cells value the othes is based another celll be
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave D-C[_2_] Dave D-C[_2_] is offline
external usenet poster
  
Posts: 5
Default how do you add-u cells value the othes is based another celll be
sparkie wrote:
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

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)






----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Reply With QuoteReply With Quote