pleeseemailme
Board Regular
- Joined
- Dec 26, 2013
- Messages
- 201
Howdy,
I have a report that spits out batches of information into a csv file. Before each batch, the report inserts the text: ">>>". I need to count the number of batches in each report, so I tried: =COUNTIF(A:A,">>>"). For whatever reason, this actually counts each cell with a value in it and not just the cells with ">>>". I've gotten around it by using the array formula: =SUM(IF(A:A=">>>",1,0)). However, I was curious if anyone could shed some light as to why the COUNTIF formula doesn't work; I'd like to learn why. Thank once again to you all.
I have a report that spits out batches of information into a csv file. Before each batch, the report inserts the text: ">>>". I need to count the number of batches in each report, so I tried: =COUNTIF(A:A,">>>"). For whatever reason, this actually counts each cell with a value in it and not just the cells with ">>>". I've gotten around it by using the array formula: =SUM(IF(A:A=">>>",1,0)). However, I was curious if anyone could shed some light as to why the COUNTIF formula doesn't work; I'd like to learn why. Thank once again to you all.