SUMIFS function
Closed
Dominic
-
7 Sep 2015 à 07:28
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 8 Sep 2015 à 11:31
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 8 Sep 2015 à 11:31
Related:
- SUMIFS function
- Hard drive function - Guide
- Network card function - Guide
- Vba find function - Guide
- Mutator function c++ - Guide
- Insert key function - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
8 Sep 2015 à 11:31
8 Sep 2015 à 11:31
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.
