Excel 2003 count cell value based on adjoining cell value
Posted on 2011-02-14
I'm trying to automate the totals counting on a paysheet. I've used the below but it only returns values if the condition exists in all cells.
However I would like to count only those that have the value of P and ignore the others. So if D8 and L8 had P it would count, but if F8 had H it would be ignored. Right now if I change the F8 the total does not change.
I have also tried a =countif(C8:O8;"P") however it counts the occurrences of P and not the value within.