Excel SUMIF With Dynamic Sum Range

[@ccba9800]

This solved my 3 hour formula headache! Thanks Alan for the great video

[@kendrewt]

What a well presented lesson! Successfully explain various hard to understand concepts in 6 minutes.

[@colin092011]

This is exactly what I need! Thank you very much for posting this. More power to you guys!

[@dhruv189]

Absolutely love this video and how clearly things have been explained. Keep it up Alan!

[@sahilpatni5288]

Worked amazing! Saved a lot of time, thanks

[@alanjarvis1892]

You're welcome!

[@suhashkantamneni673]

Thanks a lot. Very helpful.

[@bonzinho3796]

I kept getting #SPILL errors when adding the offset portion of the formula

[@MarinsFernandez]

This saved my work! Thanks!

[@alanjarvis1892]

Glad it helped!

[@sambaker5433]

Thanks great help. Can the offset be added to a SUMIFS as well as a SUMIF?

[@shelendravijayvargiya9812]

Thanks very useful information you shared

[@alanjarvis1892]

My pleasure!

[@jonathanrobinson688]

This works great. Thanks!

[@alanjarvis1892]

No problem!

[@sunnygala7972]

Thanks Alan!

[@alanjarvis1892]

My pleasure!

[@ACES_NY]

how do you do it with columns

[@ceyhunkvrak7791]

Thank you very much :)

[@alanjarvis1892]

No worries!

[@kemalayaz6459]

Süper

[@alanjarvis1892]

Thank you!

[@raturatu]

Thanks ton. I also need to make the criteria range in the sumif function a dynamic range... how do I do that ?

[@alanjarvis1892]

Take the course!

[@cabinetix]

thank you so much for this great video....however, my problem is using this formula on a google sheet in which forms add data upon Submission. Is there a way to do so?

[@alanjarvis1892]

Sorry Keith, but I teach Excel. Honestly never even come across anywhere (business) using Google sheets. You’re probably better off looking for a video dealing with that program.
Stay well.
Alan

[@cabinetix]

@@alanjarvis1892 Many thanks......

[@afifmalhas2628]

hello is there away to sum live data coming in to one cell another word i want the sum of live data and only if the live data above 500 to give me the sum total of the above 500 live data coming in

[@tariq313313]

Good