98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » SUMIFS function
SUMIFS function
Resolved · Urgent Priority · Version 2007
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?
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Counting Non Number Cells (Text)If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values. |
