Spreadsheet Solutions Service

Excel Formula Help Direct To Your Inbox For Just £1.50!

Need help with any of the following?....

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

services@spreadsheetsdirect.com

await a confirmation reply then click the PayPal link below and pay a charge of just £1.50 . Once confirmation of payment has been received your answer will be posted to your inbox within 24 hours or your money back.

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