LinkBack URL
About LinkBacks
this works for row 15 test IDs... =COUNTIFS('Working Detail'!$G:$G,R$1,'Working Detail'!$H:$H,">"&0,'Working Detail'!$I:$I,0)
sorry to do this piecemeal, also trying to do my work at work.
this works for row 15 test IDs... =COUNTIFS('Working Detail'!$G:$G,R$1,'Working Detail'!$H:$H,">"&0,'Working Detail'!$I:$I,0)
sorry to do this piecemeal, also trying to do my work at work.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Hi Sambo kid and thanks for helping me on this...
As for the sum for rows 3, 5 and 16:
So, while meeting criteria for R2 (sum the Test 1 Cases on column I in the Working Detail tab), S2 (sum the Test 1 Cases on column I in the Working Detail tab) and U2 (sum the Test 1 Cases on column I in the Working Detail tab)
So, while meeting criteria for R4 (sum the Test 1 Cases on column I in the Working Detail tab), S4 (sum the Test 1 Cases on column I in the Working Detail tab) and U4 (sum the Test 1 Cases on column I in the Working Detail tab)
So, while meeting criteria for R15 (sum the Test 1 Cases on column I in the Working Detail tab), S15 (sum the Test 1 Cases on column I in the Working Detail tab) and U15 (sum the Test 1 Cases on column I in the Working Detail tab)
Hope this clarifies things--
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks