please check the attachment, i could not make out this using vlookup, how to overcome this problem
please check the attachment, i could not make out this using vlookup, how to overcome this problem
VLOOKUP does not SUM it just LOOKS UP
Use SUMIF
=SUMIF(H$5:H$10,B5,I$5:I$10)
and copy down the column
Note: You have two different spellings of Cherries (Cherrys and Cherries) they MUST be spelt the same to pick up the correct values for the total.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thnak you K,
but the the data in the columns H & I generated from Software, that user will type in such a way. software generates a text file in that format. in excel we should make values one for fruit wise.
if you see the same for carrot it is also like car rot, i should all the values of same carrot in to one. how can i get done this using =LOOKUP(2^15,SEARCH(TRIM(LEFT(b5,4)),$h$5:$h$10),$i$5:$i$10) something like this, i have tried but not successful.
if you can help me out using some improvement.. it would be something like 1000rows aboe with different spellings
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks