Microsoft Office Forums - View Single Post - Countif multiple same range

Thread: Countif multiple same range

View Single Post

Old

03-29-2019, 06:45 PM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2007

Marcia uses Office 2007

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 527

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

Are you trying to count the number of occurrences of each data in range B5:B14?, If so, how about this formula in say, C5.

=countif(B$5:B$14,B5)

Reply With Quote