| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Not at all.
Regards, Peo Sjoblom "Bob Phillips" wrote: I like that one Peo. Do you mind if I add that to the examples on the SUMPRODUCT page? Bob "Peo Sjoblom" wrote in message ... One way =SUMPRODUCT(COUNTIF(A1:A100,{"P";"HP"}),{1;0.5}) where your P/HP days are in A1:A100 Regards, Peo Sjoblom "ryanjh79" wrote: 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
