Formula Question

A) I have a sheet with a drop-down menu that I would like a cell to "find" in another sheet and give me that description.

THEN

B) IN the Bse Price Column, I need it to go find the price for that model id and feed to that cell

THEN

C) I have the add-on column and need it to go find the price for the ones I have selected from the add-ons column, add them up, and put the total in the add-on's price column.

Can anyone do this - I am struggling! LOL

Find more posts tagged with

Accepted answers

KPH

When your column name contains a space you must use square brackets around the name in the formula:

Try this:

=SUMIF({products Range 2}, CONTAINS(@cell, [Model ID]@row ), {products Range 3})

All comments

sowell325

I still cant get it to pull the information and add up so I tried the above code listed each "Add On's" - now I am getting yet another #UNPARSEABLE result.

Any help with this would be wonderful!!!

sowell325

I changed to the above code and now I am getting the #UNPARSEABLE - any help what be wonderful! I am currently pulling my hair out! LOL

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.