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
Related:
- Sum range if 2 conditions met
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Plants vs zombies 2 pc download - Download - Strategy
- Red dead redemption 2 free download - Download - Action and adventure
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
