excel function help

  • Thread starter Thread starter erables40
  • Start date Start date
E

erables40

Hi i have a worksheet with the following set up

col A = date col B = x

what I want to do is, count all items within a certain month and b
column is not empty.
ex. count all items in column A which are in november and that column b
is not empty.
I can count the number of items in november with this formula
=SUMPRODUCT(-(MONTH(a10:a500)=11),-ISNUMBER((a10:a500)))
but how do I only count the ones which there is something written in
the b column for that month.
Thanks
 
try
=SUMPRODUCT(--(MONTH(a10:a500)=11),--ISNUMBER(a10:a500),--(B10:B500<>""))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count columns that meet criterias 3
countif function 8
use month in cell date to sum all relevant cells 2
Counting the # of values in a range ??? 8
count if condition in two columns 4
Count no. of occurance in 2 dynamic columns within a data period 7
Multiple text function calculation 5
need help writing function 9

Back
Top