Top "Worksheet-function" questions

A worksheet function is represented by a keyword in an Excel formula that performs some action on input and returns output to the calling procedure, either a worksheet cell or another function.

Sum cells in a column that have a specific value in a cell in their row

My table is as follows... Timestamp | Category | Cost -------------------------------- ... | Shopping | 5 ... | Charity | 10 ... | Dining | 20 ... | Mortgage | 1000 ... | Dining | 30 etc... What I need is a …

excel worksheet-function
Get parent folder path from file path using cell formula

In column A I have 20000 rows with filename with file path "C:\person\microsoft\ygkyg\mmddyy\filename.xls" "\server-41\performance\…

excel worksheet-function
Excel search for cell references in formulas

I inherited a big model and have been trying to reverse engineer some of the formulas. There are a lot …

excel search excel-2003 worksheet-function
Excel functions to return first row or first column from a range? (for a better 2 way lookup in table of data)

So I'm trying to do the classic 2 way lookup from a table of data, ie: Jan-00 Feb-00 Mar-00 Joe Bill …

excel worksheet-function
SumProduct over sets of cells (not contiguous)

I have a total data set that is for 4 different groupings. One of the values is the average time, the …

excel worksheet-function
Insert characters into string in different locations

I have a string which looks like this 20141007023617. And I would like to make it look like this 2014-10-07…

string excel text worksheet-function vba
The last & the first day of a month in Google Spreadsheets

What is the way to get the first and last day of the previous month in Google Spreadsheet? I tried …

google-sheets formula worksheet-function
XIRR Calculation

How do I calculate Excel's XIRR function using C#?

c# algorithm math worksheet-function
Excel formula to determine if any cells in a range contain a value

This is probably quite a basic thing to do, but I've been looking around the internet and have tried several …

excel excel-formula worksheet-function
How to categorize/classify numbers from different ranges using Excel?

I want to categorize numbers from [0:15] into 5 classes: A, B, C, D, E, F Rules: 0-1: Class A 2-4: Class …

excel excel-formula vlookup worksheet-function multiple-conditions