Kidush Hachodesh.xlsx
Im trying to do a count the items in C12thru30 that match criteria but only look at rows <= another criteria
Kidush Hachodesh.xlsx
Im trying to do a count the items in C12thru30 that match criteria but only look at rows <= another criteria
I don't understand your data. Please manually add the results you expect, tell us which cells are the results and explain the calculation you used to derive the results.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Kidush Hachodesh.xlsx
I have a table in B12:C30. In K13 and down I have the results. Im counting the number of "Pshuta"s I have in
the table including only rows <= the value in column G of the result's row.
I hopw this clearer.
I don't understand your results
Why does Pshuta in K13 show 1 when there are two values <=0, i.e. G12 & G24
Similarly
Why does Ibur in K14 show 7 when tthere are 6 values <=10, i.e. G14, G17, G19, G25, G28, G30
K13 shows 1 because in array B12:C30, including rows until the value of G13 (which is 0) there's one instance of Pshuta.
Im taking the value of a row in G, looking it up in B12:C30, and returning all "Pshuta"s in those Cs.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks