Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Biggie for me
Ok here goes;
I have a formula that finds info in a range further in the workbook ie it lpooks up a column at aa3:AF100 and returns result bck to the appropiate column in B 3:B10. Now here is problem I have another area that can add to the number in B3:B10. I made the first info go to cells in K3:K10, kleft a column blank for the new data and then sumed them in M3:M10. Here is the problem, the data to add doesnt add to each on in this maybe only be one of the rows it will add but if it doesnt match then i get a N/A andthe original numbers can not be seen. how do i make ti (If it matched one of the things in M3:M10 add the numbe to the row ie) Banana 10 0 10 Orange 10 0 10 Apple 10 0 10 onion 10 0 10 and should be Banana 10 0 10 But get N/A Orange 10 1 11 Apple 10 0 10 but get N/A onion 10 0 10 but get N/A How do i Get ti to leave blank or put a zero there? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|