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

'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

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

WPF add header to Image with URL pettitions [duplicate]

Image
up vote 0 down vote favorite This question already has an answer here: Image source URI requiring authorization 3 answers Add header to all* HTTP requests on a machine 1 answer first of all sorry for my english. Recently I added some security in the backend of my project, and now I need to send a validation code(apiKey) inside the headers to retrieve the images. I have a problem with ALL images in my project that I had attached in my UI. For example, before I had: <Image Height="90" Source="{Binding Video.Thumbnail}"/> Now I need to change my code to create a CUSTOM petition add the apiKey in the header:...
Read more