COUNTIFS Assistance

=SUMPRODUCT((Month(Tracking!$A$5:$A$105)=6)*(Tracking!$C$5:$C$105="OFSV 1")*(Tracking!$B$5:$B$105="Loss Time")*(Tracking!$L$5:$L$105,"SOC 5"))

BSB

You could use COUNTIFS for this also by using it with EOMONTH.

BSB

Thanks for the help.
Excel is returning an error when I use that formula ... I am trying to attach the actual sheet, but this system doesn't seem to want to let me do that ...
I am a newby with EOMONTH ... reading up on it right now.

I'm replying from my phone so couldn't test the formula.
If you've had no luck I'll take another look as soon as I'm in front of my laptop.

To attach a workbook click on "go advanced" under your reply then "manage attachments.

BSB

I really am trying ... but this is what I get when I try to attach:

Capture2.png

OK, don't click on that icon (it doesn't work at the moment) but instead scroll down a little and right underneath the box you type your reply in you'll see a button on the right that says "Go Advanced". Click that then "Manage Attachments". Should all be pain sailing from there.

BSB

If you have the date (1st June 2017) in a cell, in the example below I've used X1, then this formula should work:

Formula:

Please Login or Register  to view this content.

This is what I meant earlier by using EOMONTH. Adjust X1 to suit.

The SUMPRODUCT formula I proposed earlier had a slight error (I was commuting and replying from my phone, so apologies for getting it wrong!).
This should also work though.

Formula:

Please Login or Register  to view this content.

BSB

Now it is attached....

Originally Posted by Canadian911Guy

Now it is attached....

Afraid not

BSB

Your SUMPRODUCT formula worked well! Thank you!
If I have any additional problems I will try your other suggestion.
Have a great day!

Glad you've got it sorted now.

Here to help so any further issues just shout.

Don't forget to mark the thread as SOLVED if you're happy you have a working solution.
"Thread Tools / Mark as Solved"

Take care.

BSB