Spreadsheet Solutions Service

Answers to your Excel problems direct to your inbox for just £1.50!

• Are you having trouble with a spreadsheet formula?
• Not sure how to do a Pivot Table?
• Want parts of your spreadsheet to change colour depending on
  what is in another cell?
• Need to do a nested If formula but can't get it to work?
• Fed up of trawling the internet trying to find the answers?

If so then the Spreadsheets Direct Spreadsheet Solutions Service is for you. Just email your problem to

solutions@spreadsheetsdirect.com

await a confirmation reply then click the PayPal link below and pay a charge of just £1.50 (approx $2.45, €1.90). 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.

This service is for basic queries only, advanced queries need to be sent to services@spreadsheetsdirect.com

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

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

Contact

Call: 0151 324 1191 Mob: 07795 215 982 or
email: solutions@spreadsheetsdirect.com

© www.spreadsheetsdirect.com