=SUMPRODUCT(--(TEXT(Register!C2:C100,"mmmm")=B1)) I am using the above formula to count number of events in given month Register!C2:C100 has dates B1 is cell in another worksheet with month July The formula returns with 0 I have checked Register!C2:C100 with ISNUMBER and it returns TRUE Can you please help?

Support is Online

We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.

Official support hours

Monday To Friday

From 09:00 To 17:30

New

Sumproduct error

Excel

Friday, 07 September 2018

0 Replies

2.9K Visits

Votes

Undo

=SUMPRODUCT(--(TEXT(Register!C2:C100,"mmmm")=B1))

I am using the above formula to count number of events in given month Register!C2:C100 has dates
B1 is cell in another worksheet with month July
The formula returns with 0
I have checked Register!C2:C100 with ISNUMBER and it returns TRUE

Can you please help?

There are no replies made for this post yet.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Changelog

Feature Tutorials

Get Help?

Sumproduct error

Follow Us