Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

sumifs function

ResolvedVersion 2007

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?

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.

Excel tip:

Outlining - Grouping rows or columns

Highlight want you want to group and press ALT + SHIFT + left cursor arrow

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.