Countifs function equivalent for Excel 2002 (XP)
I need the functionality of COUNTIFS but for Excel 2002. I don't want to sum
but rather count. Below is the formula I would use if I had the COUNTIFS function. =COUNTIFS(A3:A7764,"PGA",J3:J7764,"x") Any suggestions? |
Countifs function equivalent for Excel 2002 (XP)
=sumproduct(--(a3:a7764="pga"),--(j3:j7764="x"))
Adjust the ranges to match--but you can't use whole columns (except in xl2007+). =sumproduct() likes to work with numbers. The -- stuff changes trues and falses to 1's and 0's. Bob Phillips explains =sumproduct() in much more detail he http://www.xldynamic.com/source/xld.SUMPRODUCT.html And J.E. McGimpsey has some notes at: http://mcgimpsey.com/excel/formulae/doubleneg.html Task Database Nightmare wrote: I need the functionality of COUNTIFS but for Excel 2002. I don't want to sum but rather count. Below is the formula I would use if I had the COUNTIFS function. =COUNTIFS(A3:A7764,"PGA",J3:J7764,"x") Any suggestions? -- Dave Peterson |
All times are GMT +1. The time now is 03:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com