| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
using countif function to add only a half of a number
I would like to use the countif function to count a letter a a half ".5"
instead of as a whole "1." The application that it would be used for is on a payroll workbook. i.e. "P" would eaqul a whole personal day whereas a "HP" would be a half of a personal day. From there I would like to add all of the "P's" and "HP's" in one Cell. this would be like 4.5 days used compared with 4 days used (P,P,P,P, HP)=4.5 Thanks, Brandon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Paste a function as a fixed number | Excel Discussion (Misc queries) | |||
| something wrong with my "countif" function | Excel Discussion (Misc queries) | |||
| #VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
| Countif Function | Excel Discussion (Misc queries) | |||
Threaded Mode
