countif 3 conditions met

Hi, Been looking through this form and can find a solution to this, so hoping that someone might have one for me. I'm using a COUNTIFS statement with multiple criteria. Use 2 sheets, 1st is call "Master" which has all the data, second is "Reports", which has all the formulas. I'm trying to...

I need a formula that compares 2 databases and returns a count if both values or within the specific range. Column A is titles Column B is values The first database is simple the range is <= 0.75 However my second database the value is in between positive 0.5 and Negative 0.5 I need a total...

We are trying to count the number of leads (segmented by Lead Score) that came in through our internet forms overnight that the call center will have to respond to on the next morning when the call-center opens. Our call center is open Monday-Thursday (7am-7pm) & Friday (7am-5pm); it is closed...

I have a column of data (A) like this: 1111 1231 1333 1112 1121 1122 1311 1333 And I have sets of these numbers which need to be COUNTIF'd they match each of the sets, for example: 1111, 1112 1221, 1321, 2432 3131, 2323 I need to get the total from column A of each set of the longer numbers. I...

hi, im having a little trouble trying to write a formula to count the occurrences of a phrase in the range B:B, but i want to count the phrases separately depending on there cells fill colour.. ie. if the cells fill colour is red it would be counted and added to the f1 cell, if blue f2, if...

I am have been trying to get a certain formula to work, for sometime, and can't find any answers, so hopefully someone can help! :) I am trying to sum the dollars of a product when they are sold, between each month, so i have several columns date column, product column, sold (y/n), and price...