SUMIFS function
Closed
Dominic
-
Sep 7, 2015 at 07:28 AM
TrowaD
TrowaD
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Related:
- SUMIFS function
- How to use sumifs function in excel with multiple sheets - Guide
- Functionality of wifi - Guide
- Which function can be used to directly bring automated data from one worksheet to another worksheet - Guide
- Function of spreadsheet - Articles
- Function key stuck on - Guide
1 reply
TrowaD
Sep 8, 2015 at 11:31 AM
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Sep 8, 2015 at 11:31 AM
Hi Dominic,
On the formula window where you input the criteria, you will find a help link in the bottom left.
Clicking on that will learn you that all criteria ranges should be the same size and that the criteria should be a single value.
You have use different range sizes and where the criteria should be you used a range as well.
The function help also shows some examples of how to use the formula correctly.
Good luck and best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
On the formula window where you input the criteria, you will find a help link in the bottom left.
Clicking on that will learn you that all criteria ranges should be the same size and that the criteria should be a single value.
You have use different range sizes and where the criteria should be you used a range as well.
The function help also shows some examples of how to use the formula correctly.
Good luck and best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.