LinkBack URL
About LinkBacks
I receive the above message when trying to use the below code. My aim is to have the cell count a specified number shown in "count" and only count if the value in the workout# cell is >89%.
Please Login or Register to view this content.
I receive the above message when trying to use the below code. My aim is to have the cell count a specified number shown in "count" and only count if the value in the workout# cell is >89%.
Please Login or Register to view this content.
I think you'd need something like this:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You do realise that function will only ever return 0 or 1, don't you?
Regards, TMS
Really? i want the function to sum, up to 5 cells, if they are over 89%. Any suggestions?
You'd have to pass a range to the function, not separate cells or values.
Please Login or Register to view this content.
Not really sure what you are trying to do. Are the cells in a column in a contiguous range? Or in a row in contiguous cells? Or random cells?
I suggest that you post a sample workbook with some examples and expected outcomes.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks