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
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!
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:
- Sum range if 2 conditions met
- Tentacle locker 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
- Fnia 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- Resident evil 2 remake free download - Download - Horror
1 response
Osama_bb11
Posts
21
Registration date
Sunday May 25, 2014
Status
Member
Last seen
September 25, 2014
Jun 26, 2014 at 01:47 AM
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
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