Forum Discussion
Solved
countif additons across multiple rows
looking for a more efficient method to calculate training compliance for a particualr city branch: I can limt to a particular city using COUNTIF(C:C,"Canberra") and then count the 'yes' returns fo...
- You could try:
=SUM((C:C="Canberra")*(D:G="y"))
If you don't have dynamic array excel version:
=SUMPRODUCT((C:C="Canberra")*(D:G="y"))
You could try:
=SUM((C:C="Canberra")*(D:G="y"))
If you don't have dynamic array excel version:
=SUMPRODUCT((C:C="Canberra")*(D:G="y"))
=SUM((C:C="Canberra")*(D:G="y"))
If you don't have dynamic array excel version:
=SUMPRODUCT((C:C="Canberra")*(D:G="y"))
thanks JMB17 - option 2 worked perfectly. I had tried SUM but must not have the higher spec version of excel.
cheers
cheers