Google sheet SUMIFs() fixed range issue [on hold]











up vote
-2
down vote

favorite












i am trying to apply the formula for sumifs based on a fixed range and i cannot get results.



please have a look at screenshots for better understanding of the issue, formula is mentioned there in formula bar and i have tried everything i could with my limited knowledge but i am not able to figure it out.



below is shareable link for the sheet and please find the sheet by the title of testing



https://docs.google.com/spreadsheets/d/14F5aCDNSr3SkudzVwLfzJVPHprg7G-34NrkepNrmfu0/edit?usp=sharing






google-sheets sumifs







share|improve this question







New contributor




Waqas Ahmad is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as unclear what you're asking by pnuts, pushkin, Nic3500, Roman Pokrovskij, Rob 1 hour ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.















  • =sumifs($D$2:$D$1000 , $C$2:$C$1000 , "Done", $E$2:$E$1000 , "Waqas") formula lies in H5 column of the sheet named Testing
    – Waqas Ahmad
    17 hours ago















up vote
-2
down vote

favorite












i am trying to apply the formula for sumifs based on a fixed range and i cannot get results.



please have a look at screenshots for better understanding of the issue, formula is mentioned there in formula bar and i have tried everything i could with my limited knowledge but i am not able to figure it out.



below is shareable link for the sheet and please find the sheet by the title of testing



https://docs.google.com/spreadsheets/d/14F5aCDNSr3SkudzVwLfzJVPHprg7G-34NrkepNrmfu0/edit?usp=sharing






google-sheets sumifs







share|improve this question







New contributor




Waqas Ahmad is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as unclear what you're asking by pnuts, pushkin, Nic3500, Roman Pokrovskij, Rob 1 hour ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.















  • =sumifs($D$2:$D$1000 , $C$2:$C$1000 , "Done", $E$2:$E$1000 , "Waqas") formula lies in H5 column of the sheet named Testing
    – Waqas Ahmad
    17 hours ago













up vote
-2
down vote

favorite









up vote
-2
down vote

favorite











i am trying to apply the formula for sumifs based on a fixed range and i cannot get results.



please have a look at screenshots for better understanding of the issue, formula is mentioned there in formula bar and i have tried everything i could with my limited knowledge but i am not able to figure it out.



below is shareable link for the sheet and please find the sheet by the title of testing



https://docs.google.com/spreadsheets/d/14F5aCDNSr3SkudzVwLfzJVPHprg7G-34NrkepNrmfu0/edit?usp=sharing






google-sheets sumifs







share|improve this question







New contributor




Waqas Ahmad is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











i am trying to apply the formula for sumifs based on a fixed range and i cannot get results.



please have a look at screenshots for better understanding of the issue, formula is mentioned there in formula bar and i have tried everything i could with my limited knowledge but i am not able to figure it out.



below is shareable link for the sheet and please find the sheet by the title of testing



https://docs.google.com/spreadsheets/d/14F5aCDNSr3SkudzVwLfzJVPHprg7G-34NrkepNrmfu0/edit?usp=sharing






google-sheets sumifs




google-sheets sumifs






share|improve this question







New contributor




Waqas Ahmad is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question







New contributor




Waqas Ahmad is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question






New contributor




Waqas Ahmad is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 17 hours ago









Waqas Ahmad

22




22




New contributor




Waqas Ahmad is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Waqas Ahmad is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Waqas Ahmad is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




put on hold as unclear what you're asking by pnuts, pushkin, Nic3500, Roman Pokrovskij, Rob 1 hour ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.






put on hold as unclear what you're asking by pnuts, pushkin, Nic3500, Roman Pokrovskij, Rob 1 hour ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.














  • =sumifs($D$2:$D$1000 , $C$2:$C$1000 , "Done", $E$2:$E$1000 , "Waqas") formula lies in H5 column of the sheet named Testing
    – Waqas Ahmad
    17 hours ago


















  • =sumifs($D$2:$D$1000 , $C$2:$C$1000 , "Done", $E$2:$E$1000 , "Waqas") formula lies in H5 column of the sheet named Testing
    – Waqas Ahmad
    17 hours ago
















=sumifs($D$2:$D$1000 , $C$2:$C$1000 , "Done", $E$2:$E$1000 , "Waqas") formula lies in H5 column of the sheet named Testing
– Waqas Ahmad
17 hours ago




=sumifs($D$2:$D$1000 , $C$2:$C$1000 , "Done", $E$2:$E$1000 , "Waqas") formula lies in H5 column of the sheet named Testing
– Waqas Ahmad
17 hours ago

















active

oldest

votes






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes

Popular posts from this blog

android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

Image
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 This is a simple project showing cubes on Unity, exported to android project and imported on Android studio. On maifest file it showed following warning: Expecting <uses-feature android:name="android.software.leanback" android:required="false" /> tag I have no information about it. And also on default emptyview android project does not use/mention this feature. I know it is required by TV's and such but why its not added by default? Why is this? And Should I concern about it? android unity3d
Read more

SQL update select statement

Image
0 I'm trying to update an entry in my database (postgresql). I'm having a problem with updating the query: INSERT INTO prices (price, product_id) SELECT product_price, commn_id FROM products_temp as prod WHERE NOT EXISTS (SELECT * FROM prices od WHERE prod.commn_id = od.product_id) OR prod.product_price != ( SELECT price FROM prices as p WHERE p.product_id = prod.commn_id order by p.end desc LIMIT 1 ) Query works fine when i delete: OR prod.product_price != ( SELECT price FROM prices as p WHERE p.product_id = prod.commn_id order by p.end desc LIMIT 1 ) So it seems to me that it's looping through this operation. My question is, how can I fix it? sql postgresql
Read more

'app-layout' is not a known element: how to share Component with different Modules

Image
0 My application was working fine until I decided to go with lazy loading: So, my shared component looks like this: import { Component, Renderer2 } from '@angular/core'; export interface FormModel { captcha?: string; } @Component({ selector: 'app-layout', templateUrl: './app-layout.component.html', styleUrls: ['./app-layout.css'] }) export class FullLayoutComponent { } app-layout.component.ts I am using this component in my Another component say school-home.component.html like this: <app-layout> </app-layout> and it was working fine until I created a Module school-home.module.ts like this: import { NgModule } from '@angular/core'; import { CommonModule } from '@angular/common'; import { SchoolhomeRoutingModule
Read more