What function do I use?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have the following column:

"Date
Form
Sent Out"

3-Nov
3-Nov
3-Nov
No Report
3-Nov
3-Nov
No Report
3-Nov
No Report
No Report
No Report
3-Nov

What function do I use to Count the Number of Cells that does not contain "No Report"?

I've been successful in counting the number of items in the column and even which one's are No Report, but I can't figure out a function for the difference.

Thanks,
 
=COUNTIF(rng,"No Report")

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
George said:
If I have the following column:

"Date
Form
Sent Out"

3-Nov
3-Nov
3-Nov
No Report
3-Nov
3-Nov
No Report
3-Nov
No Report
No Report
No Report
3-Nov

What function do I use to Count the Number of Cells that does not contain "No Report"?

I've been successful in counting the number of items in the column and
Click to expand...
even which one's are No Report, but I can't figure out a function for the
difference.
 
Oops!
=COUNTIF(A1:A10,"<>No Report")

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
George said:
If I have the following column:

"Date
Form
Sent Out"

3-Nov
3-Nov
3-Nov
No Report
3-Nov
3-Nov
No Report
3-Nov
No Report
No Report
No Report
3-Nov

What function do I use to Count the Number of Cells that does not contain "No Report"?

I've been successful in counting the number of items in the column and
Click to expand...
even which one's are No Report, but I can't figure out a function for the
difference.
 
Thanks Jim!

I appreciate your assistance...BUT I have another question related to this and am very rusty on my Excel function knowledge.

Here is more of the spreadsheet that I am working with:

A B C D E F G H I
R10 Bonnie 3-Nov 4-Dec $559.00
R10 Charles 3-Nov 4-Dec $7,575.00
R10 Daniel 3-Nov 4-Dec $2,599.00
R10 David 3-Nov 4-Dec $5,492.00
R10 David 3-Nov 4-Dec $978.00
R10 Elliott 3-Nov 4-Dec $1,491.00
R10 Gretchen No Report No Report No Report No Report $0.00 $0.00
R10 James 3-Nov 4-Dec $5,255.00
R10 Kevin 3-Nov 4-Dec $597.00
R10 Marcelo No Report No Report No Report No Report $0.00 $0.00
R10 Rob 3-Nov 4-Dec $4,434.00
R10 Jessica No Report No Report No Report No Report $0.00 $0.00

R10 26 20 20 20 $55,686.00 $0.00

I already have a formula for determining the count of RepNames in Column B.
You provided me the formula for calculating only the entries where there are dates in Column C.
Column D is calculated as Column C + 31 days.
Column E will be input as a date when the RepName returns a report to me. BUT I need to be able to COUNT the number of instances where the RepNames have returned their report. (and while excluding those that are marked No Report).
Column F will be calculated the same as Column E.
Lastly I need a formula that will allow me to automatically calculate Column I when Column F is entered with a date. Then the formula will be calculated as Column G - Column H...unless Column I contains "No Report" in which case Column I will be +(Column G).

Does this make sense?

Any help you can offer is greatly appreciated.

Thanks!
 
Sorry, it does not make good sense. Send me a small file with a clear
explanation, removing the appropriate garbage from my address.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
George said:
Thanks Jim!

I appreciate your assistance...BUT I have another question related to this
Click to expand...
and am very rusty on my Excel function knowledge.
Here is more of the spreadsheet that I am working with:

A B C D E
Click to expand...
F G H I
R10 Bonnie 3-Nov 4-Dec $559.00
R10 Charles 3-Nov 4-Dec $7,575.00
R10 Daniel 3-Nov 4-Dec $2,599.00
R10 David 3-Nov 4-Dec $5,492.00
R10 David 3-Nov 4-Dec $978.00
R10 Elliott 3-Nov 4-Dec $1,491.00
R10 Gretchen No Report No Report No Report No Report $0.00 $0.00
R10 James 3-Nov 4-Dec $5,255.00
R10 Kevin 3-Nov 4-Dec $597.00
R10 Marcelo No Report No Report No Report No Report $0.00 $0.00
R10 Rob 3-Nov 4-Dec $4,434.00
R10 Jessica No Report No Report No Report No Report $0.00 $0.00

R10 26 20 20 20 $55,686.00 $0.00

I already have a formula for determining the count of RepNames in Column B.
You provided me the formula for calculating only the entries where there are dates in Column C.
Column D is calculated as Column C + 31 days.
Column E will be input as a date when the RepName returns a report to me.
Click to expand...
BUT I need to be able to COUNT the number of instances where the RepNames
have returned their report. (and while excluding those that are marked No
Report).
Column F will be calculated the same as Column E.
Lastly I need a formula that will allow me to automatically calculate
Click to expand...
Column I when Column F is entered with a date. Then the formula will be
calculated as Column G - Column H...unless Column I contains "No Report" in
which case Column I will be +(Column G).
 
Back
Top