Hi all
I'm new here
What I'm trying to do is count the number of entries in a range of cells with a certain criteria - that part's easy (=countif(range,"code"), but I also want to add a criteria affecting a separate range which is loosely connected to this range (in attached workbook: if range AH16:AK35 = "g", and the colour shown in AO16:35 = 2nd criteria in the pricing sheet.)
I can count the number of the codes, but I need to count the number of codes using a certain colour which is displayed in a different range.
I know it's a very messy workbook but it's inherited & I'm trying to make it better .. *sigh*
Many thanks.
FatFoot
Bookmarks