cleetus_snow
New Member
- Joined
- Jun 16, 2002
- Messages
- 10
I have seen many great examples of counting using sumproduct. Each has counted based on an AND condition. Can sumproduct be used to count based on an OR condition?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Counting with sumproduct
- Thread starter cleetus_snow
- Start date
cleetus_snow
New Member
- Joined
- Jun 16, 2002
- Messages
- 10
Because my workbook will be deployed throughout my office, I'm hesitant to go the add-in route for COUNTDIFF. I will work with it myself to learn how this function works. Thanks for the suggestion Aladin.
I have tried and will use the SUMPRODUCT function as proposed by Domenic:
=SUMPRODUCT(--(COUNTIF(OFFSET($A$1:A8,ROW($A$1:A8)-MIN(ROW($A$1:A8)),0,1),1)>0))
Thanks to everyone for curing my headache!!
I have tried and will use the SUMPRODUCT function as proposed by Domenic:
=SUMPRODUCT(--(COUNTIF(OFFSET($A$1:A8,ROW($A$1:A8)-MIN(ROW($A$1:A8)),0,1),1)>0))
Thanks to everyone for curing my headache!!
Upvote
0
Excel Facts
Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
cleetus_snow said:
The add-in allows itself to be included in the workbook you want to distribute.
Upvote
0
