excel - How to refer to multiple adjacent cells -


i have work sheet in there several cells specific entry - let's "a". these not in same rows/columns. after each cell date. need count number of cells containing "a" have specific date in cell right. i've tried combinations of countifs , indirect, no success. how can achieve this?

this counts number of times there a in column , 1 in column b

=sumproduct(($a$1:$a$5="a")*($b$1:$b$5=1)) 

this outputs in cell d1

enter image description here


Comments

Popular posts from this blog

php - Embed BBCode within itself not working -

three.js - how to load gltf in three JS -

sql server - T-SQL: Access DB objects in same schema without qualifying? -