Recent content by RadMan

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...