logo

Site search
powered by FreeFind

Contact


Mobile: 07795 215 982
Email:
Spreadsheets Direct

*New Answer Service*:
Spreadsheet Solutions

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

www.spreadsheetsdirect.com
To enable Javascript follow the instructions here.

AddThis Social Bookmark Button

Social Media