Idea Function similar to Excel CountIF function
ThDon
Forums
Hi guys,
Please help me with a function that is similar to the Excel COUNTIF function which counts the number of cells in a range, that meets a given criteria.
I want to count number of records that match a particular criteria, in my case i want to sum all records' totals before a certain sum total is reached. These records are ordered in time, as such the count/sum should be in time sequence.
Could you not do this using a
Could you not do this using a summary with a criteria in which the criteria excludes the sum total? You might also be able to do this with a straight criteria and then do a total on it.