Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help... only have 20 mins
Sorry for my urgence... I need to find a way to sum a value if the right 3 digits of a code are equal to another code in other sheet. Example: Sheet 1 A------------------B---------------------C Code-------------Field1----------------Value 0231241---------xxxxxxx---------------10020 0032241---------yyyyyy---------------750 0212120---------zzzzzzz---------------1002 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help... only have 20 mins
Hi, Not really got time to check it but won't something along the lines of: insert a column next to column A in sheet 1 (you can hide it later). in cell 1 of inserted column write '=right(A1,3)', drag down the rest of the column This will retrieve the last three digits of the code in column A. Then wherever you want the count write '=countif(B2:B3000,241)'. You could probably do it with the countif function from the start but it would be hard. -- coa01gsb ------------------------------------------------------------------------ coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214 View this thread: http://www.excelforum.com/showthread...hreadid=563194 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set XL formula to add mins to a time i.e add 45mins to 8am to get | Excel Discussion (Misc queries) | |||
Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
How to convert numeric value to mins and addimg mins to Hrs. | Excel Worksheet Functions | |||
Calculate difference (mins) between 2 Times | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |