Log In
Create Account
SlickerTalk
Search Archives
The Leaderboard
The FAQ
Login
Create Account
Search
Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...
RSS Feed
Hosting by DigitalOcean
Support ST on Ko-Fi
Links Only
50 Results
100 Results
250 Results
500 Results
1000 Results
5000 Results
2 Weeks
2 Months
6 Months
1 Year
2 Years
5 Years
All Time
Live
Down to Post
Backboards:
Live
________________
1: Nov 28, 16:19
2: Nov 28, 09:42
3: Nov 27, 18:07
4: Nov 27, 12:04
5: Nov 27, 08:26
6: Nov 26, 18:06
7: Nov 26, 12:05
8: Nov 26, 08:29
9: Nov 25, 18:33
10: Nov 25, 11:12
11: Nov 25, 07:08
12: Nov 24, 13:17
13: Nov 23, 18:13
14: Nov 23, 06:17
15: Nov 22, 13:24
16: Nov 22, 09:09
17: Nov 21, 22:36
18: Nov 21, 14:03
19: Nov 21, 10:18
20: Nov 21, 07:35
Posts: 155
excel heads, what is "ROW" doing here? -- (edited)
Posted by
amanda
Apr 29 '22, 12:56
=INDEX(D4:D6, SUMPRODUCT(--($D$8<=C4:C6), --($D$8>=B4:B6), ROW(A1:A3)))
why the eff can't I get this dumb thing to work?
INDEX + SUMPRODUCT + ROW
(www.get-digital-help.com)
Responses:
If I understand it correctly: -- (edited)
-
oblique
Apr 29, 13:12
Is *that* why your Friday meeting? -- nm
-
Spawn
Apr 29, 13:00
1
That was to complete my deliverable from the meeting. -- nm
-
Pocket Jones
Apr 29, 14:13
I think it might convert "A3" into "3", for example -- nm
-
Beryllium
Apr 29, 12:59
4
yup, I think it's giving the Value column (from the website example) numbers to correspond to the letters A,C and B -- nm
-
decline
Apr 29, 13:07
2
also I think that formula has an error in it
-
decline
Apr 29, 13:11
1
yeah, I caught that. thanks all! -- nm
-
amanda
Apr 29, 13:12
mayyyyyyybe. lemme try something -- nm
-
amanda
Apr 29, 13:00
If I read that right, Row is used for the second argument of the Index function after the criteria exclude non-relevant numbers. -- nm*
-
Max
Apr 29, 12:58
Post a message
top
Replies are disabled on threads older than 7 days.
