| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I sum currency values in a row containing currency and uni.
I would like to sum up only the £ values in a row containing £ and units.
Ideally I would also sum £ values only within a specified date range ( I achieved this already with SUMIF but am unable to combine the two conditions. Ps. The data is not structured to allow the use of conditional sum wizard Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i sum values with Different currency Format? | Excel Discussion (Misc queries) | |||
| To get a sum for variant currency values | Excel Discussion (Misc queries) | |||
| Increase a currency grid values by 3% | Excel Discussion (Misc queries) | |||
| How do I hide zero values but keep currency format in P.O. form? | New Users to Excel | |||
| Why are some currency values of 0 in red? I want all black. | Charts and Charting in Excel | |||
Threaded Mode
