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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I sum currency values in a row containing currency anduni.
How is your data arranged, then? Do you have alternate £ values and
units? Please give some more details, with examples of what you have now. Pete On Nov 13, 12:51*pm, Eusebius wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I sum currency values in a row containing currency and uni.
use sumproduct with col a and col b with col c to be summed =sumproduct(--(a2:a22=cond1),--(b2:b22=cond2),c2:c22) -- Don Guillett Microsoft MVP Excel SalesAid Software "Eusebius" wrote in message ... 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 |
Reply |
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 |