I have data that is pulled every week and subgrouped based on Count, and I have to do the following function in multiple columns in the new spreadsheet every week.....
=COUNTIF(G2:G8,">=0:16")
I need to copy this down the entire column (upto 1500 rows) every week, where the rows are subgrouped based on the client name in column A
In the attached file:
column H shows the result that I'm looking for from G - using the formula above
I really don't want to have to change the range over 100 times every week.
Ideas? I tried using a different formula that I am using for something else....
=IFERROR(SUM(IF(FREQUENCY(IF(ISNUMBER(SEARCH(" Total",A2)),IF(SUBSTITUTE(A2," Total","")=$A$2:$A$64,INT($E$2:$E$64),""),""),IF(ISNUMBER(SEARCH(" Total",A2)),IF(SUBSTITUTE(A2," Total","")=$A$2:$A$64,INT($E$2:$E$64),""),"")),1,0)),"")
but couldn't figure out where the countif formula goes.....
Bookmarks