Sign in to join the conversation:
Hi,
I have 2 columns, one with a product description(Different products on a 1000 cells) and the other column it is their individual value. May you assist on how to get a sum of, say "shirts" only from the product description column?
Hi Tsholanang,
Try something like this.
Replace "Shirts" with what you want to SUM.
=SUMIF([Product Description]:[Product Description]; "Shirts"; [Individual Value]:[Individual Value])
The same version but with the below changes for your and others convenience.
=SUMIF([Product Description]:[Product Description], "Shirts", [Individual Value]:[Individual Value])
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Has anyone figured out a way to use a column as a created date but not have the time stamp? It causes problems for my manager trying to use that date to pull into PBI. I know how to convert in a helper column to a year-month and a year, but those have to be text/number columns, not date columns and he can't use those…
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…
