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

  • Thread starter Thread starter Eusebius
  • Start date Start date
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
 
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
 
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
sum 2
Add alternate cells in column and sum 4
Using SUM + INDEX in array formula 5
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
How do I put a variable column number in the sum() function? 7
Complex conditional summing - array COUNT works, array SUM gives#VALUE 4
Sum below a specific row 1

Back
Top