Search results

Wow, completely over my head. But it seems like it will work. I'll have to study it for a while. Thanks

Hello, I've been searching multiple sites for a solution to this problem. I'm trying to lookup similar Text in column A and return the sum of all corresponding values in column J. I find vlookup is good for finding a particular value when the text is only found once in a column, but i'm...

Hi, I've looked all over for an answer for this and can't find any. I'm not sure it can be done. Here's and example. On the right i'm trying to come up with a formula that looks to the name on the right and puts a category name on the right of it such as Automobile and Groceries...

I'm not sure how to use that. I'm looking for something like this. =IF(B:B="Restaurant",then C:C="Dining") But i want to do that with a number of different categories. Almost like vlookup but i want it to lookup a number of words and return a word rather then a number all the way down...

Thank you bobhc, But what i'm trying to do is change a bunch of specific transactions from one column to read as a specific category in an adjacent column. So the idea is that it looks all the way down a column for a given value and then changes it to another value to the right of it. For...

Hi, I'm not sure where to even look this up. Thanks

I figured it out. Thanks all.

Hi, I found a lot on adding sales between dates. But i would like to add sales from one date as a reference. I'm trying to formulate the sum of and extract all "John" sales since a beginning date. And then separately, sum all of his sales older then 14 days before the beginning date...

Works!! thank you

Hello, I've searched the forum for examples of SUMIFS formulas. There's a lot on adding the total for a column when the criteria for two columns meet. But I'm trying to add a column when one criteria is in an adjacent column and the other is in a single cell on the same spreadsheet. Any...

Thank you. I'll do a search on SUMIF function.

Hello, I would like my spreadsheet to look for and total all Groceries and Gas & Fuel into 2 separate cells as i paste my banking transactions into a range of cells. Is it possible to automatically add all my Groceries and Gas & Fuel category's, respectively, using a function or Conditional...

I got it. Thank you.

Unless there's an easy way to copy and paste just the CF, I have 21 seperate entries for each day of the month. It's based on the day of the month and the threshold set for each day.

The link below is a adjustable monthly schedule for employees. C74:AG76 are my missing assignments for any given day. When this missing assignment for any given day of the week reaches a threshold it turns red. (Keep in mind that this schedule changes as i adjust A1)----I would like the...

I'm trying to highlight the top of a schedule when a red cell at the bottom of the spreadsheet turns red.

Hello, Is this conditional formating? Thanks

Narayan, After working with the weekday function, i figured it out. Thanks for all your help. :) Mark

Narayan, When I change month the days of the week change automatically. That's perfect. This is an employee assignment schedule. Each day of the week has a predetermined number of hours that use. Such at 80 hours for Monday, 120 hours for Tuesday, 60 hours for Saturday. So these hours...

Hui, How does that function work? Will it change when i change my month in A1? I found the function in the tabs. Just not sure what to do with it. Thanks Mark

Thanks :)

Hello, I love the tags to the left, but a search option would be more specific for trying to find an answer before i post a question. How do i find my favorites for this forum? Thanks Mark

Hello, Is it possible to have numbers or alph/num follow the days of the week in an adjustable monthly column calendar? As i change the month the days of the week correspond to the dates of the month. Can i have certain values follow every Monday as i change the month...

Works!! thank you both :)

Thanks But it seems to just copy what's in B1 to E1 when I put the value "aa" in D1. https://docs.google.com/open?id=1-zZAeE0NijWLKbY6WJDoGwdFpVrLkHbOAwKbpzZD6x67g2yecZa3_TqpbCCl Radman/WorkingMan