ADDING CELLS WHICH ARE <> THAN OTHER CELLS
I am trying to formulate a formula or macro.
Cells A1:A10 if greater than 8000 add figure in B1:B10 a1 = 8015 b1 = 1000 a2 = 7999 b2 = 1000 a3 = 8066 b3 = 4 a4 = 6000 b4 = 28 the answer i need will be 1004 Thanks heaps who ever can help me |
=SUMIF(A1:A10,"8000",B1:B10)
HTH Jason Atlanta, GA -----Original Message----- I am trying to formulate a formula or macro. Cells A1:A10 if greater than 8000 add figure in B1:B10 a1 = 8015 b1 = 1000 a2 = 7999 b2 = 1000 a3 = 8066 b3 = 4 a4 = 6000 b4 = 28 the answer i need will be 1004 Thanks heaps who ever can help me . |
You are to be commended for a proper subject line (better if NOT all caps)
and clearly stating your problem along with the desired result. Life around here would be easier if all did the same instead of "urgent question for MVP's only" please read my mind I need my column to be added from my desire etc. -- Don Guillett SalesAid Software "boogie" wrote in message ... I am trying to formulate a formula or macro. Cells A1:A10 if greater than 8000 add figure in B1:B10 a1 = 8015 b1 = 1000 a2 = 7999 b2 = 1000 a3 = 8066 b3 = 4 a4 = 6000 b4 = 28 the answer i need will be 1004 Thanks heaps who ever can help me |
All times are GMT +1. The time now is 11:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com