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

Using SUM + INDEX in array formula 5
sum 2
Complex conditional summing - array COUNT works, array SUM gives#VALUE 4
How do I sum cells that have values from a text formula? 4
Sum Number of Rows based on Value in Another Cell 2
How do I put a variable column number in the sum() function? 8
How do I sum currency only numbers in a range? 2
Why can't I sum several vlookups ?? 5

Top