Countifs?

1legin · May 20th 2018

Hi

Iam trying to find a formula to get the number of times a number appears on a given day, Please see below

Code

This is just a small section of the page


Trying to find  totals for Fri & Tue for each number


   [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 273"]
 	 		[TR]
 			[TD="class: xl63, width: 33"] [/TD]
 			[TD="class: xl63, width: 27"] [/TD]
 			[TD="class: xl63, width: 24"] [/TD]
 			[TD="class: xl63, width: 24"] [/TD]
 			[TD="class: xl63, width: 24"] [/TD]
 			[TD="class: xl63, width: 24"] [/TD]
 			[TD="class: xl63, width: 21"] [/TD]
 			[TD="class: xl63, width: 21"] [/TD]
 			[TD="class: xl63, width: 10"] [/TD]
 			[TD="class: xl63, width: 38"] [/TD]
 			[TD="class: xl63, width: 38"] [/TD]
 			[TD="width: 39"] [/TD]
 			[TD="class: xl63, width: 39"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl65"]Day[/TD]
 			[TD="class: xl65"]N1[/TD]
 			[TD="class: xl65"]N2[/TD]
 			[TD="class: xl65"]N3[/TD]
 			[TD="class: xl65"]N4[/TD]
 			[TD="class: xl65"]N5[/TD]
 			[TD="class: xl65"]L1[/TD]
 			[TD="class: xl65"]L2[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl65"]No.'s[/TD]
 			[TD="class: xl65"]All[/TD]
 			[TD="class: xl65"]Fri[/TD]
 			[TD="class: xl65"]Tue[/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Fri[/TD]
 			[TD="class: xl64"]5[/TD]
 			[TD="class: xl64"]8[/TD]
 			[TD="class: xl64"]10[/TD]
 			[TD="class: xl64"]13[/TD]
 			[TD="class: xl64"]31[/TD]
 			[TD="class: xl64"]3[/TD]
 			[TD="class: xl64"]6[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]1[/TD]
 			[TD="class: xl63"]9[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Tue[/TD]
 			[TD="class: xl64"]4[/TD]
 			[TD="class: xl64"]16[/TD]
 			[TD="class: xl64"]20[/TD]
 			[TD="class: xl64"]31[/TD]
 			[TD="class: xl64"]39[/TD]
 			[TD="class: xl64"]2[/TD]
 			[TD="class: xl64"]12[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]2[/TD]
 			[TD="class: xl63"]4[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Fri[/TD]
 			[TD="class: xl64"]3[/TD]
 			[TD="class: xl64"]22[/TD]
 			[TD="class: xl64"]34[/TD]
 			[TD="class: xl64"]49[/TD]
 			[TD="class: xl64"]50[/TD]
 			[TD="class: xl64"]8[/TD]
 			[TD="class: xl64"]11[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]3[/TD]
 			[TD="class: xl63"]10[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Tue[/TD]
 			[TD="class: xl64"]17[/TD]
 			[TD="class: xl64"]25[/TD]
 			[TD="class: xl64"]35[/TD]
 			[TD="class: xl64"]39[/TD]
 			[TD="class: xl64"]44[/TD]
 			[TD="class: xl64"]2[/TD]
 			[TD="class: xl64"]5[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]4[/TD]
 			[TD="class: xl63"]9[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Fri[/TD]
 			[TD="class: xl64"]6[/TD]
 			[TD="class: xl64"]12[/TD]
 			[TD="class: xl64"]23[/TD]
 			[TD="class: xl64"]39[/TD]
 			[TD="class: xl64"]45[/TD]
 			[TD="class: xl64"]9[/TD]
 			[TD="class: xl64"]12[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]5[/TD]
 			[TD="class: xl63"]10[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Tue[/TD]
 			[TD="class: xl64"]6[/TD]
 			[TD="class: xl64"]15[/TD]
 			[TD="class: xl64"]17[/TD]
 			[TD="class: xl64"]42[/TD]
 			[TD="class: xl64"]48[/TD]
 			[TD="class: xl64"]4[/TD]
 			[TD="class: xl64"]6[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]6[/TD]
 			[TD="class: xl63"]9[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Fri[/TD]
 			[TD="class: xl64"]12[/TD]
 			[TD="class: xl64"]24[/TD]
 			[TD="class: xl64"]40[/TD]
 			[TD="class: xl64"]41[/TD]
 			[TD="class: xl64"]46[/TD]
 			[TD="class: xl64"]5[/TD]
 			[TD="class: xl64"]12[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]7[/TD]
 			[TD="class: xl63"]6[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Tue[/TD]
 			[TD="class: xl64"]20[/TD]
 			[TD="class: xl64"]23[/TD]
 			[TD="class: xl64"]28[/TD]
 			[TD="class: xl64"]30[/TD]
 			[TD="class: xl64"]44[/TD]
 			[TD="class: xl64"]3[/TD]
 			[TD="class: xl64"]7[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]8[/TD]
 			[TD="class: xl63"]10[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Fri[/TD]
 			[TD="class: xl64"]3[/TD]
 			[TD="class: xl64"]16[/TD]
 			[TD="class: xl64"]25[/TD]
 			[TD="class: xl64"]39[/TD]
 			[TD="class: xl64"]44[/TD]
 			[TD="class: xl64"]7[/TD]
 			[TD="class: xl64"]11[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]9[/TD]
 			[TD="class: xl63"]10[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Tue[/TD]
 			[TD="class: xl64"]15[/TD]
 			[TD="class: xl64"]27[/TD]
 			[TD="class: xl64"]33[/TD]
 			[TD="class: xl64"]39[/TD]
 			[TD="class: xl64"]50[/TD]
 			[TD="class: xl64"]4[/TD]
 			[TD="class: xl64"]6[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]10[/TD]
 			[TD="class: xl63"]10[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Fri[/TD]
 			[TD="class: xl64"]5[/TD]
 			[TD="class: xl64"]25[/TD]
 			[TD="class: xl64"]34[/TD]
 			[TD="class: xl64"]48[/TD]
 			[TD="class: xl64"]50[/TD]
 			[TD="class: xl64"]6[/TD]
 			[TD="class: xl64"]7[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]11[/TD]
 			[TD="class: xl63"]9[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Tue[/TD]
 			[TD="class: xl64"]14[/TD]
 			[TD="class: xl64"]27[/TD]
 			[TD="class: xl64"]39[/TD]
 			[TD="class: xl64"]46[/TD]
 			[TD="class: xl64"]48[/TD]
 			[TD="class: xl64"]11[/TD]
 			[TD="class: xl64"]12[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]12[/TD]
 			[TD="class: xl63"]12[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 		[TR]
 			[TD="class: xl64"]Fri[/TD]
 			[TD="class: xl64"]1[/TD]
 			[TD="class: xl64"]29[/TD]
 			[TD="class: xl64"]33[/TD]
 			[TD="class: xl64"]45[/TD]
 			[TD="class: xl64"]47[/TD]
 			[TD="class: xl64"]4[/TD]
 			[TD="class: xl64"]8[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl64"]13[/TD]
 			[TD="class: xl63"]8[/TD]
 			[TD="class: xl63"] [/TD]
 			[TD="class: xl63"] [/TD]
 		[/TR]
 	 [/TABLE]

Display More

Thanks

Nigel

**alansidman** · May 20th 2018

It will be easier to help you if you provide a small sample file instead of data inserted into the thread. No one really wants to try and reconstruct your information, guessing at data type and formatting.

Countifs?

Participate now!

Share