I have a total formula in column E that works great. The formula is [ =IF(B2<>B3,SUMPRODUCT(--($
),"")] My spreadsheet is sorted by the B Number (Column B) and a second level sort on Days (Column D). I need a formula that can count the ZXZ in column A for the same B number. I need to know how many B numbers are related to the ZXZ. For example, the 1st B number is 008589926 and I have 2 ZXZ (Cell A7 and A8) so in cell F8 in should have 4. I tried several different formulas, but I can’t get it to work. Please help. Thank you.