Sum Values based on Other Cells | Google Sheets

[@demonyomel]

Thank you very much! Easy to understand and a big help for my work!

[@RivasyaKazei]

Straightforward and easy to understand, thank you so much!

[@ProlificOaktree]

Glad it was helpful!

[@madisonpalomo6470]

This was helpful. Thank you!!

[@ProlificOaktree]

Glad it was helpful!

[@ohnoez768]

Very helpful, thank you so much!

[@ProlificOaktree]

Glad it was helpful!

[@jiteshsonar5591]

Excellent ! Thank you very much sir

[@ProlificOaktree]

Any time!

[@plazafriburgo4539]

BRO JUST SAVED ME HOURS

[@ProlificOaktree]

BRO

[@michaelsenerchia6698]

Just what I was looking for. Thank you.

[@amosmuturi162]

Thanks, easy and straightforward

[@ProlificOaktree]

Glad it helped.

[@lasanthicolambage2139]

Thank you so much! It is a very helpful & easy lesson!😊😊😊

[@ProlificOaktree]

Glad to hear that!

[@AnnieBleich]

So helpful thank you

[@ProlificOaktree]

Glad it was helpful!

[@scottfung7700]

Thank you very much. That is exactly what I am trying to do.

[@HDExhibition]

Thanks, amazing video

[@ProlificOaktree]

Glad you liked it!

[@melissasaboljt]

I'm getting a blank row under the header items when I do the Query. I can't figure out how to get rid of it, though I'm sure it is simple. Please help. This is my formula =QUERY(A6:G,"select B, sum(G) group by B",1). Thank you.

[@melissasaboljt]

Also, is there a way to remove the word "sum" from the header?

[@ProlificOaktree]

Try this: sheetshelp.com/query-remove-blank-rows/

[@ProlificOaktree]

Adjust the range you're using or the third parameter of the query that deals with header rows.

[@melissasaboljt]

@@ProlificOaktree thank you for replying, but maybe there is a miscommunication. The blank row I'm trying to get rid of is right under the header row of the Query between the header and the results. even with a simple table it still shows up. it is just frustrating and I'm curious why, but not that big of a deal. This video was very helpful. I appreciate it.

[@SheetsHelp]

@@melissasaboljt It sounds to me like the URL I gave you addresses this. 🤷

[@ThaoNguyen-gc2pu]

i will watch every single ad for you if it jump up Bro. your explaination is so kind.

[@ProlificOaktree]

You 'da man!

[@7cabeca7]

Query was the best way for me, thanks

[@ThaoNguyen-gc2pu]

thanks so so much! you are awesome.

[@mensa1950]

Excellent! TY!

[@ProlificOaktree]

You're welcome!

[@elaineee1996]

thank you!

[@ProlificOaktree]

You're welcome!

[@PrioSembodo]

Thanks

[@ProlificOaktree]

Welcome