Previous Topic Next Topic

Sum range if 2 conditions met

Closed
Portiapuss
Posts
1
Registration date
Wednesday June 25, 2014
Status
Member
Last seen
June 25, 2014
 - Jun 25, 2014 at 02:07 PM
Osama_bb11
Posts
22
Registration date
Sunday May 25, 2014
Status
Member
Last seen
September 25, 2014
 - Jun 26, 2014 at 01:47 AM
Hi, I have arrange of numbers which I would like to sum in a certain cell, only if a column contains certain text and another column contains another different text i.e.

Cell D10 sum range in column c, if range in column B = LOA3 and range in column A = WBA

I could combine the LOA3 and WBA in to one cell, bit I wondered if I could leave them in separate columns.

Many thanks!

1 reply

Answer 1 / 1
Osama_bb11
Posts
22
Registration date
Sunday May 25, 2014
Status
Member
Last seen
September 25, 2014
Jun 26, 2014 at 01:47 AM
Hello ,

this is my understanding

you want to find the sum of cells from D1 .. D10 ( the sum at D12 ) but this sum will be subject to two conditions c1=col and b1=wba so it will be

D12=if(and(c1="col",b1="wba"),sum(d1:d10),"")

make the changes to above example to fit your requirements

I hope this will works
0