SUM |
SUMIF |
SUMPRODUCT |
COUNT |
COUNTA |
COUNTIF |
AVERAGE |
MIN |
MAX |
VLOOKUP |
INDIRECT |
RANK |
NOW |
DATE |
TODAY |
DSUM |
DCOUNT |
IF |
PIVOT TABLES |
CONDITIONAL FORMATTING |
GRAPHS |
PROTECTION |
SUBTOTALS |
TEXT TO COLUMNS |
If so then the Spreadsheets Direct Spreadsheet Solutions Service is for you. Just email your problem to
Please click below to pay.
Some example queries:
Q: I have a list of student names in column A and their marks in column B. What formula do I use to find the total marks for John?
A: Use the SUMIF function =SUMIF(Range to search for name in, name to search for, range to add up) e.g. =SUMIF(A2:A100,"John",B2:B100).
Q: I have a list of product codes and descriptions in columns A & B on a sheet called Products in Products.xls. In Stock sheet in Stock.xls I have product code and stock. How do I put descriptions from Products.xls next to the product code in Stock.xls?
A: Use the VLOOKUP function =VLOOKUP(cell to match, range to search, column to return, TRUE for nearest match or FALSE for exact match) e.g. =VLOOKUP(A2,'[products.xls]products'!$A$2:$B$10,2,FALSE).