how do I sum currency values in a row containing currency and uni.

E

Eusebius

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
 
P

Pete_UK

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
 
D

Don Guillett

use sumproduct with col a and col b with col c to be summed
=sumproduct(--(a2:a22=cond1),--(b2:b22=cond2),c2:c22)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sum currency only numbers in a range? 2
How do I sum cells that have values from a text formula? 4
How to sum only Nagative or only postive values in a row ? 1
summing first 'n' values in a column or row 4
How can I find a value from one cell in a char string in another? 2
sumif with "broad" sum range 7
How do I sum values in a row if the value in a row above = text 2
sum cells in table using column and row conditions 2

Top