SOLVED

Formula for Countif

Copper Contributor

Good Morning Guys 

 

I'm trying to do a countif formula. I want to count the amount of entrys in B based on the ranges between E&F to be added to total in H. Can any help. I've not really done ranges before. Or if anyone can suggest an alternative. I have enclosed a test excel. 

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Jamesb1982 

Does the COUNTIFS in the attached sample file return the intended result?

It seems to. thank you for that.
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Jamesb1982 

Does the COUNTIFS in the attached sample file return the intended result?

View solution in original post