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 21 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!
Related:

1 response

Answer 1 / 1
Osama_bb11 Posts 21 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