T thifu3 New Member Feb 4, 2013 #1 Hello guys! Is it possible that i can count the following using a formula. i want to check how many trousers are in medium size etc and how may shorts are small or medium. [pre] Code: Trouser Small Shirt Medium Shirt Large Shirt Medium [/pre]
Hello guys! Is it possible that i can count the following using a formula. i want to check how many trousers are in medium size etc and how may shorts are small or medium. [pre] Code: Trouser Small Shirt Medium Shirt Large Shirt Medium [/pre]
S sdsurzh Member Feb 4, 2013 #2 Hi, Can you please download the below file and check. http://www.2shared.com/file/m8bxVDyB/Book2.html Thanks, Suresh Kumar S
Hi, Can you please download the below file and check. http://www.2shared.com/file/m8bxVDyB/Book2.html Thanks, Suresh Kumar S
bobhc Excel Ninja Feb 4, 2013 #3 Good day thifu3 This formila in C1 and then pulled down you data range, =COUNTIFS($B:$B,B1) will give you this [pre] Code: A B C Trouser Small 1 Shirt Medium 2 Shirt Large 1 Shirt Medium [/pre]
Good day thifu3 This formila in C1 and then pulled down you data range, =COUNTIFS($B:$B,B1) will give you this [pre] Code: A B C Trouser Small 1 Shirt Medium 2 Shirt Large 1 Shirt Medium [/pre]
Faseeh Excel Ninja Feb 4, 2013 #4 Hi thifu3, The formula should be like: =SUMPRODUCT((Type_Range="Trouser")*(Size_Range={"Medium","Small","Large"})) You can delete from "Medium","Small","Large" things you don't want to count. you can also change trouser to shirt as well. Regards,
Hi thifu3, The formula should be like: =SUMPRODUCT((Type_Range="Trouser")*(Size_Range={"Medium","Small","Large"})) You can delete from "Medium","Small","Large" things you don't want to count. you can also change trouser to shirt as well. Regards,
