SOLVED

# Help with function COUNTIF

Occasional Contributor

# Help with function COUNTIF

I am trying to count the cells in a column that contain a number value but only if another cell in the same row contains the specified text. (possibly using wrong function?) see below for example

I need to count all the cells contain a number value by lets say month of Dec

16 Replies

# Re: Help with function COUNTIF

You will need to apply a COUNTIFS function since you are reviewing more than one criteria. See the example below:

Best Response confirmed by AaronC92 (Occasional Contributor)
Solution

# Re: Help with function COUNTIF

@AaronC92

=+COUNTIFS(E2:E7,E11,F2:F7,"<>")

 Month nov 1 dec 1 nov dec nov 2 dec 2 dec =+COUNTIFS(E2:E7,E11,F2:F7,"<>")

As variants

# Re: Help with function COUNTIF

Thank you all for the help! this works perfectly!

Go's to show I need to brush up on my excel skills

# Re: Help with function COUNTIF

That's what each of us do every day

# Re: Help with function COUNTIF

I am working on the last section of this excel sheet and I need a formula to figure the commissions earned.

It needs to add all the number values in a column then multiply that by the commission lets say \$200 per entry.

I have found a way to do it but its a long and absurd method (needs to be cleaned up bad)

Don't Laugh but this is my poor attempt to try and solve this issue

Each of the purple cells contains a value similar to this (=C8*200)

# Re: Help with function COUNTIF

Sorry, but that's not clear, at least for me. Where is C8, is 200 fixed for all entries or variable, are column numbers variable or fixed, do you have total column in any case or that's just helper. In general = TotalInRow*200.

# Re: Help with function COUNTIF

I apologies, I rushed that question started getting busy at the office.

Yes, the 200 is fixed for all entry's in that column but it needs to only count the values by the specified month like before

# Re: Help with function COUNTIF

Sorry, but I don't see months at all on your screenshot. Could you please give bit more details, desirably with sample file, when you have time.

# Re: Help with function COUNTIF

Here is a sample of the doc I'm working on.

On the tracker page I am trying to calculate the \$200 commissions earned for each home on the data page by month.

# Re: Help with function COUNTIF

Thank you, but file doesn't explain the logic for me. Why for Jan you calculate sum of working hours * 200, but for Nov Changes*2? I'm not in your business and have no idea what's that about, if you explain more close to Excel terms that will be great.

# Re: Help with function COUNTIF

The purple is old and is no longer correct, so yeah that wont make any sense just ignore that completely.

I just need a formula to take all the values in the home column in the specified month like Jan or any month and multiply that by \$200 to replace the no longer working formula in the "Estimated Monthly Commission Total"

Once I have a working formula for that I'm sure I can edit to fit for the other months and change the commission rate for the different products.

Hope that helped clear things up

# Re: Help with function COUNTIF

At this point I can just delete the purple mess

# Re: Help with function COUNTIF

If like this that's

``=SUMIFS(Table3[Home],Table3[Date],Tracker!B4)*200``

# Re: Help with function COUNTIF

This is exactly what I needed! thank you

# Re: Help with function COUNTIF

@AaronC92 , you are welcome