Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I know this isn't strictly a VBA question but it is used in my spreadsheet that

you've helped on before.

I have a countif function counting for particular letters and times by the cell

value above it but occasionally the cells lose the references.

I want to count multiple letters and this is the way I have found works but is

there a better way?

Note the + inbetween each countif statement.

=COUNTIF(B7,"H")*B6+COUNTIF(B7,"B")*B6+COUNTIF(B7,"HD")*B6

You are a star as always.

That work perfectly. I think because I've adapted my spreadsheet to work in

another way I didn't consider changing the way it counted the cells.

And by losing the references i meant that the countif's would lose the reference

to which cell they were looking at and i an only presume it was my rubbish

statement that was doing it.

Once again thank you for your time.

See if this one gives you what you need:

=ISNUMBER(MATCH(B7,{"H";"HD";"B"},0))*B6

Didn't find what you were looking for?
Find more on CountIF Function
Or get search suggestion and latest updates.

Related Topics:

- Need help for COUNTIF
- Excel 2000 Sumif/Countif
- Wait function and Invisible function
- Wait function and Invisible function
- How can I call the function TotalPrice within another function?
- help on functions
- Problems with XL's 'MATCH' function
- Excel won't calculate my function
- User Function - is optional calculation possibe?
- Automatic update of Function return value.
- String-Split Function parameter "compare"
- function as argument
- Need to create function smiliar to DMAX
- Logistic Regression (Statistical Functions)
- Wierd problem in VBA code re Mid function
- function question
- function to change the color of the cell
- User Defined Function didn't work
- How does the Worksheets function work?
- Converting Date functions
- user-designed Excel math functions
- Convert Serial Number to a Date Function
- date Function
- Math function to determine if a number is an int
- HttpContext.Current function returns Nothing for spawned thread