Previous Topic Next Topic

Sum range if 2 conditions met

Closed
Portiapuss Posts 1 Registration date Wednesday 25 June 2014 Status Member Last seen 25 June 2014 - 25 Jun 2014 à 14:07
Osama_bb11 Posts 21 Registration date Sunday 25 May 2014 Status Member Last seen 25 September 2014 - 26 Jun 2014 à 01:47
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

Réponse 1 / 1
Osama_bb11 Posts 21 Registration date Sunday 25 May 2014 Status Member Last seen 25 September 2014
26 Jun 2014 à 01:47
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