SUMIF i think?

ExcelRoy · Nov 15, 2020

Hi all,

I am using the following formula to count a total from column G, this works fine

Now i am trying to get a total number from column C but with no duplicates, trying to work out using the similar formula but cant get it working

Any help appreciated

Thanks

ExcelRoy · Nov 15, 2020

AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3957	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3062a	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3633	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3626ap01	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	970c00	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	973p90	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3024	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3839a	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3460	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3022	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3034	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3298p90	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3933	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3934	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3829c01	1.2.12.1
AA5/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3842a	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3957	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3062a	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3959	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3626ap01	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	970c00	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	973p90	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3794	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	2	122c01	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3020	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3795	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3039	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	4	3641	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3829c01	1.2.12.1
AA6/AA1	Buggy	12	SYS/S/C/1/2/2/G	1	3842a	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3956	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	2	3787	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3937	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3938	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3959	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3626ap01	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	970c00	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	973p90	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3024	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	2	3023	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3794	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3022	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	2	122c01	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	2	3021	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3020	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3795	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3960	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	4	3641	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3829c01	1.2.12.1
AA9/AA1	Truck	12	SYS/S/C/1/2/2/G	1	3842a	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3957	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3062a	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3963	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3959	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3626ap01	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	970c00	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	973p90	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3024	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3024	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3023	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3794	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3839a	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3475b	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3623	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3460	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3021	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3020	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	3	3795	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3035	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3298p90	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3039p34	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3479	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3936	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3935	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	2	3829c01	1.2.12.1
WES/AA1	Scooter	12	SYS/S/C/1/2/2/G	1	3842a	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3957	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3005	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3062a	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3062a	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	4	3004	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3004p90	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	3	3065	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3622	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3001	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3788	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3787	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3937	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3938	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3831	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3830	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3876	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3959	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3626ap01	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	970c00	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	973p90	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3024	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3023	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3794	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3839a	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3710	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3022	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3731	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3730	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	4	122c01	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	4	3021	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3020	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3034	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3960	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3039p23	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3651	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3070b	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	3	3069b	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3680c01	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	8	3641	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3829c01	1.2.12.1
PPL/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3842a	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3957	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3956	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3062a	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3963	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3941	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	6	3941	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	5	3787	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3942a	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3942a	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3937	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3938	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3324c01	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3962a	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3626ap01	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	970c00	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	970c00	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	973p90	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	973p90	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3024	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3024	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	3	3023	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3794	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3794	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3022	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3731	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3730	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	5	122c01	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	3	3020	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	3	3795	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3034	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3960	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3039p23	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	2	3479	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3680c01	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	10	3641	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3829c01	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3842a	1.2.12.1
EE14/AA1	Mobile	12	SYS/S/C/1/2/2/G	1	3842a	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3957	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3956	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3005	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3004	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3622	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	3	3010	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3010p41	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3010p918	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3963	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3941	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3943a	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3822	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3821	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3937	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3938	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3626ap01	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	970c00	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	973p90	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3024	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3024	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3024	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	4	3023	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3839a	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3710	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3666	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3022	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3021	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3020	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3020	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3795	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3795	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	3	3034	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3832	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3031	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3032	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3035	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3939	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3939p91	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3660	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	10	3660	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	3	3940	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3479	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	2	3069b	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	3	3933	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	3	3934	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3829c01	1.2.12.1
CCS/AA1	Ship	12	SYS/S/C/1/2/2/G	1	3842a	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	3	3957	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3947	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	4	3956	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	3	3956	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	7	3005	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3062a	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3062a	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	3	3062a	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	7	3004	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3622	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3010	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	9	3066	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	4	3009	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3008	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3003	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3941	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	6	3941	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	11	3941	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	8	3941	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3002	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3788	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3787	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3942a	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3942a	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3937	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3938	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3149c01	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	3	x467	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3838	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3838	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3962a	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	3	3626ap01	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	970c00	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	970c00	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	4006	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	973p90	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	973p90	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3024	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	4	3024	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3024	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3023	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3023	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	3	3794	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	8	3839a	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	2	3710	1.2.12.1
FS2/AA8	Pad	12	SYS/S/C/1/2/2/G	1	3710	1.2.12.1

ExcelRoy · Nov 15, 2020

Sorry for huge post

example 3957 is listed on 7 lines (3 on FS2/AA8), but has a total of 9, so the formula i have gives me the 9, but i need a formula that gives me the 7

Thanks

Fluff · Nov 15, 2020

Ok if that data is cols A:G how about

Excel Formula:

=COUNTIFS(F:F,H2)

where H2 holds the value you want to count.

ExcelRoy · Nov 15, 2020

not quite, i need column A counted but with no duplicates, then the total from E

Thanks

Fluff · Nov 15, 2020

So where does the 3957 come in?

ExcelRoy · Nov 15, 2020

the 3957 is what we are counting, so there is a total of 9 in teh list of data, but in 7 job/references only

i would like to show the following

"There is a total of 9 lines of 3957 being used in 7 different jobs"

Thanks

Fluff · Nov 15, 2020

Sorry but I'm not getting this, there are 7 different rows where 3957 occurs & that is what my formula returns. In what way is that wrong?

ExcelRoy · Nov 16, 2020

Hi Fluff,

Works a treat, sorry don't know what i did wrong last night

Many thanks for your help!

Fluff · Nov 16, 2020

You're welcome & thanks for the feedback.

SUMIF i think?

ExcelRoy

Well-known Member

ExcelRoy

Well-known Member

Excel Facts

ExcelRoy

Well-known Member

Fluff

MrExcel MVP, Moderator

ExcelRoy

Well-known Member

Fluff

MrExcel MVP, Moderator

ExcelRoy

Well-known Member

Fluff

MrExcel MVP, Moderator

ExcelRoy

Well-known Member

Fluff

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

SUMIF i think?

Well-known Member

Well-known Member

Excel Facts

Well-known Member

MrExcel MVP, Moderator

Well-known Member

MrExcel MVP, Moderator

Well-known Member

MrExcel MVP, Moderator

Well-known Member

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock