sumifs function
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » SUMIFS function

SUMIFS function

resolvedResolved · Urgent Priority · Version 2007

replyReply Thu 15 Dec 2011, 15:42Delegate Sandra said...

Sandra has attended:
Excel Advanced course
Excel Advanced course

SUMIFS function

I cant get a sumifs function to work. I tried splitting it to sumif and it worked but with a sumifs I get a #value come back.

I checked it and so have my colleagues but we dont know why it wont work. Can you help?

Can I send you the file please?

For upcoming training course dates see: Pricing & availability

replyReply Wed 21 Dec 2011, 13:10Trainer Jacob said...

RE: SUMIFS function

Hi Sandra

From your post we would really need to see a copy of your spreadsheet to troubleshoot the issues you are having.

As this falls outside the scope of the forum we would ask you to email us a copy of your spreadsheet for review.

If we can help we will get back to you with how long it will take and any related costs to do this.

Please reply to me email if you would like to proceed this further.

Kind regards

Jacob

Wed 28 Dec 2011: Automatically marked as resolved.

 

Please browse our web site to find out more about
excel in courses and other Microsoft training courses.

Excel tip:

Jumping Across the Excel Screen

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Alt+PgDn and Alt+PgUp is the equivalent across the spreadsheet.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard