Thread: [Solved] count a number of cells based on the beginning of a order number
View Single Post
 
Old 08-06-2017, 08:39 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
If you put the codes in H25 to H29, you could use this array formula in I25:
=SUM(IF(LEFT(H$1:H$23,2)=H25,I$1:I$23,0))
then copy the formula down to I29.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote