Need sum function if project name is found in cell with alt enter used to list projects

**NS4Excel** · 01-30-2015, 08:21 PM

Timesheet.xlsx

Columns AM thru AS show project names. Col B shows all of the projects that this resource worked on.
I need a formula for cells AM12 thru AS14 that will calculate the costs if the project in row 7 is listed in col B.

Thanks.

**FDibbins** · 01-30-2015, 08:28 PM

Try this...
=IF(ISNUMBER(FIND(AM$7,$B11,1)),$AK11*$AL11,"")
copied down and across

(I kinda figured there was more to your other question

)

**NS4Excel** · 01-30-2015, 08:55 PM

You guys are the best! Thank you soooooo much. This is a huge help.

**FDibbins** · 01-30-2015, 08:58 PM

Again, happy to help

Need sum function if project name is found in cell with alt enter used to list projects

LinkBack

Thread Tools

Rate This Thread

Display

Need sum function if project name is found in cell with alt enter used to list projects

Re: Need sum function if project name is found in cell with alt enter used to list project

Re: Need sum function if project name is found in cell with alt enter used to list project

Re: Need sum function if project name is found in cell with alt enter used to list project

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Delete projects in project window

Can't remove VBA projects from project window

[SOLVED] Insert Blank Rows between sorted projects, Subtotal project to the right of final project.

ghost VBA Projects and VBA Project password window popup

Old Projects in Project Window

Bookmarks

Bookmarks

Posting Permissions