| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CountIf function
Hello
I have a countif function... =COUNTIF(D3:D59,"0") However I need to also incorporate into this to flag 3 rows that I don't want to include in this calculation but I'm not sure how to exclude them. Does anyone have any suggestions? |
|
#2
|
|||
|
|||
|
One way............ could be
=COUNTIF(D3:D59,"0")-3 -- Greetings from New Zealand Bill K "Julie" wrote in message ... Hello I have a countif function... =COUNTIF(D3:D59,"0") However I need to also incorporate into this to flag 3 rows that I don't want to include in this calculation but I'm not sure how to exclude them. Does anyone have any suggestions? |
|
#3
|
|||
|
|||
|
As an example
=COUNTIF(D3:D59,"0")-(D100)-(D170)-(D190) -- HTH RP (remove nothere from the email address if mailing direct) "Julie" wrote in message ... Hello I have a countif function... =COUNTIF(D3:D59,"0") However I need to also incorporate into this to flag 3 rows that I don't want to include in this calculation but I'm not sure how to exclude them. Does anyone have any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Date & Time | New Users to Excel | |||
| Countif Function -Nested | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| How do I use COUNTIF in a SUBTOTAL function to differentiate the . | Excel Worksheet Functions | |||
Linear Mode
