Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find a word in a table, then use a function
Hi everybody
I have a table with the days of the week, and the shifts for each one eg S1 Sun S2 Sun S3 Sun S1 Mon S2 Mon etc on column A and in column B, the number of items manufactured On another table, (column D) i have ONLY the days Sun Mon Tue etc What I want to do is to sum in column E the total for each day, by reference to column D something like "find this value in the other table, and add them" usually i would have use the sumif my problem is with the shifts so i need to find the cells that contains especific text to sum |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find function Pivot Table | Excel Discussion (Misc queries) | |||
Link table from excel to word using word VBA | Excel Discussion (Misc queries) | |||
What function will find a value in a table with X & Y Values | Excel Worksheet Functions | |||
Can I Find one word in a formula | Excel Worksheet Functions | |||
Find a word and then take certain action, else | Excel Worksheet Functions |