Count number of paired numbers and ignore #N/A, across columns

E

excelsior22

New Member
Joined
Dec 30, 2018
Messages
2
Hi there,

I would greatly appreciate any help - I have been trying to solve this all day! I am trying to count all the instances that a real number in columns C/E/G/I/K/M/O is paired with a real number in column D/F/H/J/L/N/P, respectively.
In this example, the count would be 28. An example of a positive count is in C4/D4 as both are numerical. C3/D3 shouldn't be counted as C3 is #N/A. I hope that makes sense.

9f840ada-9aba-4ca3-873d-c206dc402f55
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
[TABLE="width: 1185"]
<colgroup><col width="128" style="width: 96pt;"><col width="49" style="width: 37pt;"><col width="72" span="14" style="width: 54pt;"></colgroup><tbody>[TR]
[TD="class: xl79, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl79, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl79, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]A[/TD]
[TD="class: xl80, width: 49, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] "]B[/TD]
[TD="class: xl81, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]C[/TD]
[TD="class: xl82, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]D[/TD]
[TD="class: xl83, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]E[/TD]
[TD="class: xl83, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]F[/TD]
[TD="class: xl84, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]G[/TD]
[TD="class: xl82, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]H[/TD]
[TD="class: xl85, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]I[/TD]
[TD="class: xl83, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]J[/TD]
[TD="class: xl84, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]K[/TD]
[TD="class: xl82, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]L[/TD]
[TD="class: xl83, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]M[/TD]
[TD="class: xl83, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]N[/TD]
[TD="class: xl81, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]O[/TD]
[TD="class: xl82, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"]P[/TD]
[/TR]
[TR]
[TD="class: xl79, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl79, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl79, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl80, width: 49, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] "] 1[/TD]
[TD="class: xl81, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl82, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"] [/TD]
[TD="class: xl83, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl83, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl84, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl82, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"] [/TD]
[TD="class: xl85, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl83, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl84, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl82, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"] [/TD]
[TD="class: xl83, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl83, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl81, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl82, width: 72, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"] [/TD]
[/TR]
[TR]
[TD="class: xl94, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl94, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl94, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] "] 2[/TD]
[TD="class: xl86, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl86, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl86, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl86, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: center"][/TD]
[/TR]
[TR]
[TD="class: xl92, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"][/TD]
[TD="class: xl92, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"][/TD]
[TD="class: xl92, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"][/TD]
[TD="class: xl75, align: center"]3[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.18[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]0.34[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.34[/TD]
[TD="class: xl65, align: center"]2451.00[/TD]
[TD="class: xl65, align: center"]0.30[/TD]
[TD="class: xl66, align: center"]2127.00[/TD]
[TD="class: xl67, align: center"]0.44[/TD]
[TD="class: xl65, align: center"]1739.00[/TD]
[TD="class: xl65, align: center"]0.24[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]4[/TD]
[TD="class: xl66, align: center"]4193.00[/TD]
[TD="class: xl67, align: center"]0.28[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]5[/TD]
[TD="class: xl66, align: center"]2154.00[/TD]
[TD="class: xl67, align: center"]0.04[/TD]
[TD="class: xl65, align: center"]1528.00[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.06[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]6[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.44[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]7[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.44[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]8[/TD]
[TD="class: xl66, align: center"]1724.00[/TD]
[TD="class: xl67, align: center"]0.28[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]9[/TD]
[TD="class: xl66, align: center"]942.00[/TD]
[TD="class: xl67, align: center"]0.55[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]0.48[/TD]
[TD="class: xl66, align: center"]606.00[/TD]
[TD="class: xl67, align: center"]0.42[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]10[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.22[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]0.24[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.12[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]0.20[/TD]
[TD="class: xl66, align: center"]3755.00[/TD]
[TD="class: xl67, align: center"]0.04[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]0.10[/TD]
[TD="class: xl66, align: center"]2924.00[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]11[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.48[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]0.14[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.10[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]0.00[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.00[/TD]
[TD="class: xl65, align: center"]2926.00[/TD]
[TD="class: xl65, align: center"]0.00[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.04[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]12[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.00[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]13[/TD]
[TD="class: xl66, align: center"]4826.00[/TD]
[TD="class: xl67, align: center"]0.00[/TD]
[TD="class: xl65, align: center"]4719.00[/TD]
[TD="class: xl65, align: center"]0.00[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]14[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.20[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl75, align: center"]15[/TD]
[TD="class: xl66, align: center"]1485.00[/TD]
[TD="class: xl67, align: center"]0.48[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl76, align: center"]16[/TD]
[TD="class: xl70, align: center"]950.00[/TD]
[TD="class: xl73, align: center"]0.55[/TD]
[TD="class: xl71, align: center"]#N/A[/TD]
[TD="class: xl71, align: center"]#N/A[/TD]
[TD="class: xl70, align: center"]#N/A[/TD]
[TD="class: xl73, align: center"]#N/A[/TD]
[TD="class: xl71, align: center"]#N/A[/TD]
[TD="class: xl71, align: center"]#N/A[/TD]
[TD="class: xl70, align: center"]#N/A[/TD]
[TD="class: xl73, align: center"]#N/A[/TD]
[TD="class: xl71, align: center"]#N/A[/TD]
[TD="class: xl71, align: center"]#N/A[/TD]
[TD="class: xl70, align: center"]#N/A[/TD]
[TD="class: xl73, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl89, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"][/TD]
[TD="class: xl89, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"][/TD]
[TD="class: xl89, width: 128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"][/TD]
[TD="class: xl74, align: center"]17[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl72, align: center"]0.18[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl72, align: center"]0.54[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl72, align: center"]0.38[/TD]
[TD="class: xl69, align: center"]2741.00[/TD]
[TD="class: xl69, align: center"]0.36[/TD]
[TD="class: xl68, align: center"]2556.00[/TD]
[TD="class: xl72, align: center"]0.44[/TD]
[TD="class: xl69, align: center"]2054.00[/TD]
[TD="class: xl69, align: center"]0.32[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl72, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]18[/TD]
[TD="class: xl66, align: center"]4016.00[/TD]
[TD="class: xl67, align: center"]0.54[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]19[/TD]
[TD="class: xl66, align: center"]2292.00[/TD]
[TD="class: xl67, align: center"]0.12[/TD]
[TD="class: xl66, align: center"]1560.00[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.02[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]20[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.36[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]21[/TD]
[TD="class: xl66, align: center"]1528.00[/TD]
[TD="class: xl67, align: center"]0.52[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]22[/TD]
[TD="class: xl66, align: center"]1720.00[/TD]
[TD="class: xl67, align: center"]0.28[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]23[/TD]
[TD="class: xl66, align: center"]802.00[/TD]
[TD="class: xl67, align: center"]0.55[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.52[/TD]
[TD="class: xl66, align: center"]620.00[/TD]
[TD="class: xl67, align: center"]0.52[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]24[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.12[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.10[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.12[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]0.02[/TD]
[TD="class: xl66, align: center"]3700.00[/TD]
[TD="class: xl67, align: center"]0.20[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]0.02[/TD]
[TD="class: xl66, align: center"]2551.00[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]25[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.08[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.04[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.06[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]0.00[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.00[/TD]
[TD="class: xl65, align: center"]2693.00[/TD]
[TD="class: xl65, align: center"]0.04[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.04[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]26[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.00[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]27[/TD]
[TD="class: xl66, align: center"]4535.00[/TD]
[TD="class: xl67, align: center"]0.00[/TD]
[TD="class: xl66, align: center"]4039.00[/TD]
[TD="class: xl67, align: center"]0.00[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]28[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.48[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl77, align: center"]29[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]0.88[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl65, align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[TD="class: xl67, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl78, align: center"]30[/TD]
[TD="class: xl70, align: center"]701.00[/TD]
[TD="class: xl73, align: center"]0.70[/TD]
[TD="class: xl70, align: center"]#N/A[/TD]
[TD="class: xl73, align: center"]#N/A[/TD]
[TD="class: xl70, align: center"]#N/A[/TD]
[TD="class: xl73, align: center"]#N/A[/TD]
[TD="class: xl71, align: center"]#N/A[/TD]
[TD="class: xl71, align: center"]#N/A[/TD]
[TD="class: xl70, align: center"]#N/A[/TD]
[TD="class: xl73, align: center"]#N/A[/TD]
[TD="class: xl71, align: center"]#N/A[/TD]
[TD="class: xl71, align: center"]#N/A[/TD]
[TD="class: xl70, align: center"]#N/A[/TD]
[TD="class: xl73, align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Lambda or VBA to solve the pairs webinar problem!!!
Replies
0
Views
101
Phantom1
P
T
  • Solved
Formula to Number Multi-Part Transactions and Re-Start Count Each Day
Replies
6
Views
276
turn7or5
T
D
  • Solved
Counting Consecutive Blanks
Replies
9
Views
653
felixstraube
F
A
  • Solved
count how many times text string appears in column
Replies
2
Views
197
ajm
A
E
  • Question Question
Autofill function across columns
Replies
1
Views
188
arun_eagertolearn
A

Forum statistics

Threads
1,223,958
Messages
6,175,637
Members
452,663
Latest member
MEMEH

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top