## Sumif to find sum of values with a given name in a given month

Trying to find a sumif formula that will return the sum of values with a given name in a given month. I have multiple entries within each month that are …

Microsoft Excel Formulas in Excel

Trying to find a sumif formula that will return the sum of values with a given name in a given month. I have multiple entries within each month that are …

The cost of materials is $22.59. One person can assemble four per hour. You pay that person $10.25 per hour. The cost of packaging is $1.50 and it takes 5 …

I have a list of products in my excel sheet1 (A:A contains the product code, B:B contains the color of item) On sheet2, I would like to have a summary table …

I just put the formula of averageifs in the sheet to with linked to database which is sheet one when drag the row downward it shows an error”the …

Hi, I’m wondering if there is a way to use the Count function while assigning different values to different texts. More specifically, I’m trying to …

NOTES 1. Use a formula to find the appropriate hire category in the above table 2. …

Quesion: Input Column A Column B Row A1 XXX …

i think it should be done with match vlookup and offset but its too complicated. i need to show differences between revenues of client between 2016 month five …

Hi There How can I ammend the formula so that the cell does not reflect the word false but rather keep the cell blank. …

Hi all, (system= windows 7 excel 2013) I’m trying to make a formula that will show me the trend in selling prices. My system shows me everytime a …

Hi,Please, can someone help me with an Excel formula for finding a Selling Price calculation based on known margin required & Cost Price (Ex. VAT)?Thanks …

How can I track overall completion % date wise on a working day basis or on a daily basis automatically? By: Lebin

Hi, I am trying to create a formula that expressed the following (in regard to time in hours): If F17 is less than 6:00, 0 If F17 is greater than …

Office 365 version of Excel Data is taken from an external system – copied on screen (ctrl+a ctrl+c) This is then pasted into a sheet within a workbook …

I have a list of people on a spread sheet this also includes email addresses. However when I want to email these people I have to insert a comma after their …

I want the automated values in ROW 21 to show how much more or less revenue we made that weekday (weekdays in ROW 7). Total revenue a day in ROW 20. I …

I currently have this formula =sumproduct(––isnumber(match(Closers!A:A,‘Consent to Contract’!E:E,0))) This is counting all matching …

Hi, I usually use 5 Workbooks (Week-1,Wee-2,Week-3,Week-4 and Master) but for this example lets use “Week-1” and “Master” workbooks. I …

I have a situation where I have 3 different “categories” but 4 differernt formulas. SO, let’s say my categories are Dogs, Cats, and Fish. I …

Dear Excelgeek, I need your help to make formula for my study, here is the result table: Male Result Age Very Good Good Fair Poor Very Poor 10 …

I want to track document log where I want to get Auto update of Status as “OPEN” or “CLOSED” by inserting document submission date and …

the data: 9/1 9/2 9/3 9/4 ~> 9/30 group b x x x x x group b x x x x x group a x y x x y group c x y y y y group c x y y y y group b x x …

hi, i have a question at excel. if you can help me?? i need to do data analysing graphs from excel, and they look more or the less the same like this one. and …

i am trying to look up values of column C from column A and get respective column B values in column D. So for this i am using this formula in D1 : …

I haven’t been able to find an answer by viewing other people’s questions. So I am hoping I can get this answered. I am currently using the …

Hi, I am just wondering why my IF function is not working correctly. Any help is appreciated. By:

I am currently using this formula it does work but doesnt do what i need it to: =IF(E17,”Complete”,”In Progress”) …

Hello, so I am trying to create a volunteer hour tracker for my organization where people will go in add their name and other information about their …

I have this situation. I am trying to calculate: In cell B14 shows a drop down list for Freight terms and you need to choose whether it is Prepaid and …

I am creating a spreadsheet that models the sale of some single family homes. I have built a sale schedule that says X of the homes are to be sold per month, …

If a row has conditional formatting that makes dates older than today’s date highlight red, and I only want this to trigger if a row has a name (or any …

How do I use the AVERAGEIF formula if there is a range that I wish to exclude? As an example: If I am working out the average mark of students for their …

Hi, I am building a offer excel program to car shop. How to link specific data shown in certain are, when I have chosen a car model. I have chosen a mark and …

Hi. I am looking to create an excel sheet where I enter in a cell (Cell A1) a number, which logs that amount in another cell (B2). Then when I enter in the …

I am wondering how I can set up a formula to calculate the dollar amount earned per rep based on the individual GA sales when the Store total hits a tier. I …

When I am using Excel16 or Excel 16 for Mac. I have 3 columns A B C 1 first name last name password 2 John Smith …

Hi – I have a cell where the output should render the year that sales start in a particular geography, ie. Europe Launch? XXX This is driven from …

I have a sheet (Contacts) with my customer contacts in it and a separate sheet (Customers) with my customer companies in it. The “Contacts” …

I’m trying to get my “IF” function to calculate a formula that involves time. So I have a time “hh:mm” in column A and I have …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.