Countif - add another condition
I have tried the Microsoft help but the formula simply doesn't work. Attached sheet is a smaller/simplified version of what I'm trying to do with a set of data.
I have a table of data showing all instances of each colour, then I want to break it down into each colour within each shape. i could filter and count but my actual data is 8 different shapes & 31 different colours [data types changed to make it simpler]
I'm very new to formulas more complicated than sum etc so all help appreciated in the simplest of terms please.
Last edited by Excel Beginner99; 09-14-2010 at 11:16 AM.
Re: Countif - can't seem to add in another condition
You want to count the colours across all 3 columns? Try this formula in B17 copied across and down
Note that could count the same row twice, e.g. there are 4 yellow circles because it counts 2 in row 4
Re: Countif - add another condition
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1