![]() I have even tried specifying the sheet label in every cell reference, =COUNTIFS(EventLog.$I$2:"#EventLog.$I"&Summary.$F$2,A28,EventLog.$D$2:"#EventLog.$D"&Summary.$F$2,Constants.$B$1) Works perfectly, but does not protect me from future growth… However, specifying a fixed range, =COUNTIFS(EventLog.$I$2:I$300,A28,EventLog.$D$2:D$300,Constants.$B$1) Attempting to trace the invalid argument doesn’t really help, arrows point toĬells A28 and $F$2, with a single further arrow pointing to a small diamond blob that does nothing… However, in a Summary sheet I count (and sum) all eventlog entries that match the criteria in A28 and Constants.$B$1. The indirection is in E2, =HYPERLINK("#EventLog.$B"&$F$2+1,"Next event")Īs stated, this works perfectly. The cell that locates the next entry is F2, containing =MAX(EventLog.$A2:$A300)+1 In the EventLog, column A contains an incrementing sequence number, column B the event date. It doesn’t work, or I have got something wrong. That log has grown beyond the original limits and inĪnticipation of future growth, I tried to get similar indirection to work in COUNTIFS and SUMIFS. To link to the next entry in an event log. (I also get the same error in “AndrOpen Office 5.2.2” which is based on Openoffice 4.1.12)įor a long time I have been building a cell reference out of fixed text and the content of a cell Indirect cell reference (possibly) does not work in COUNTIFS and SUMIFS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |