![#Excel Sumif Example Reel by @techwithhelen - How do I use SUMIF and SUMIFS functions in Excel?
=SUMIF(range, criteria, [sum_range])
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_rang](https://image.pictame.com/img/502370005_555937904250676_7712607178474452570_n.jpg?hash=aHR0cHM6Ly9zY29udGVudC1wcmcxLTEuY2RuaW5zdGFncmFtLmNvbS92L3Q1MS43MTg3OC0xNS81MDIzNzAwMDVfNTU1OTM3OTA0MjUwNjc2Xzc3MTI2MDcxNzg0NzQ0NTI1NzBfbi5qcGc/c3RwPWRzdC1qcGdfZTM1X3M2NDB4NjQwX3R0NiZfbmNfY2F0PTEwMiZjY2I9Ny01Jl9uY19zaWQ9MThkZTc0JmVmZz1leUpsWm1kZmRHRm5Jam9pUTB4SlVGTXVZbVZ6ZEY5cGJXRm5aVjkxY214blpXNHVRek1pZlElM0QlM0QmX25jX29oYz1CU1dWU2pwbWZia1E3a052d0hna2dVOCZfbmNfb2M9QWRxaktGRzRwTHF4eDMwbUQ1SmFGaVZiZXJvUnh4QlJnSWFxOWF2QWZMWmRObTh2WEd6TDdlX1BCS2VsRWZEaU83cyZfbmNfenQ9MjMmX25jX2h0PXNjb250ZW50LXByZzEtMS5jZG5pbnN0YWdyYW0uY29tJl9uY19naWQ9NjlzbFpXenZZcFZDemFkaUdFWkJYdyZfbmNfc3M9NzA2ODkmb2g9MDBfQWY1aWNONmJsb1g2ekFIekVRSXFYMjI2OFBSc1RTYjR2LXcyZGwwNUI2RGdzQSZvZT02OUZERTJCQg==)
66.8K
TEHow do I use SUMIF and SUMIFS functions in Excel?
=SUMIF(range, criteria, [sum_range])
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
#excelfunctions #excelvbaprogrammming
#exceltips #exceltutorial #exceltipsandtricks
#microsoftexcel #spreadsheets #productivityhacks #dataanalysis
#excelshortcuts #excelskills #excelmasteryskills #excel #exceldashboard #excelforbeginners #excelforbusiness #businessintelligence
@techwithhelen


![#Excel Sumif Example Reel by @excelsimplifi_ed - Want to know How to Use SUMIF Function in Excel the right way?
Here's the syntax:
=SUMIF(range, criteria, [sum_range])
✔ range - the cells you want](https://image.pictame.com/img/642138779_17898399063403466_6501162347357467670_n.jpg?hash=aHR0cHM6Ly9zY29udGVudC1wcmcxLTEuY2RuaW5zdGFncmFtLmNvbS92L3Q1MS44Mjc4Ny0xNS82NDIxMzg3NzlfMTc4OTgzOTkwNjM0MDM0NjZfNjUwMTE2MjM0NzM1NzQ2NzY3MF9uLmpwZz9zdHA9ZHN0LWpwZ19lMzVfczY0MHg2NDBfdHQ2Jl9uY19jYXQ9MTA3JmNjYj03LTUmX25jX3NpZD0xOGRlNzQmZWZnPWV5SmxabWRmZEdGbklqb2lRMHhKVUZNdVltVnpkRjlwYldGblpWOTFjbXhuWlc0dVF6TWlmUSUzRCUzRCZfbmNfb2hjPWhJTmpsLU14UEI0UTdrTnZ3R1NfVGtUJl9uY19vYz1BZG8yQi1ZZU5KclJJQW9OYmdQUnE4N3dzRmpXZF94TkgydjU3a0k2bDZ4YkZBOUQxdmhRejFTb1RMd21YdmlIRGowJl9uY196dD0yMyZfbmNfaHQ9c2NvbnRlbnQtcHJnMS0xLmNkbmluc3RhZ3JhbS5jb20mX25jX2dpZD02OXNsWld6dllwVkN6YWRpR0VaQlh3Jl9uY19zcz03MDY4OSZvaD0wMF9BZjVzeXVtVUo4MVZXRFM3eFpaYTRkbDhtNF9kUmZjR1RLUUFCWWJUUkhselRRJm9lPTY5RkRGRTA4)







