count non blank cells which meet criteria in another column
I'm working with 2 columns out of an Excel spreadsheet. First column "B" is
list of names (some cells may be blank) and the second column "F" contains years (2001, 2002, etc.). I'd like to count non blank cells in "B" which meet the criteria (2005) in the years "F" column. |
Hi
one method =SUMPRODUCT(--(B7:B100<""),--(F7:F100=2005)) Cheers JulieD "cmarsh5035" wrote in message ... I'm working with 2 columns out of an Excel spreadsheet. First column "B" is list of names (some cells may be blank) and the second column "F" contains years (2001, 2002, etc.). I'd like to count non blank cells in "B" which meet the criteria (2005) in the years "F" column. |
oops forgot to say,
for details on the SUMPRODUCT function check out http://www.xldynamic.com/source/xld.SUMPRODUCT.html "cmarsh5035" wrote in message ... I'm working with 2 columns out of an Excel spreadsheet. First column "B" is list of names (some cells may be blank) and the second column "F" contains years (2001, 2002, etc.). I'd like to count non blank cells in "B" which meet the criteria (2005) in the years "F" column. |
All times are GMT +1. The time now is 08:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com