| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Values for Y and N in multiple cells
I
am adding up C2:C7, but I want to stay within the same row when converting the "Y" or "N" to the value I set for it. In other words this is how I want it to work... C2 Y (value I set in formula = +1) C3 3 C4 N (value I set in formula = -2) C5 10 C6 Y (value I set in formula = +3) C7 2 C8 17 (Total) Any Ideas? Corey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum up values only in cells that are color filled? | Excel Worksheet Functions | |||
| How to sum values in multiple worksheets | Excel Worksheet Functions | |||
| Multiple X-Axis Values | Charts and Charting in Excel | |||
| Adding multiple cells, return specific values | Excel Worksheet Functions | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Threaded Mode
