Hello everyone,
How can I use the SUMIFS function to sum all the values in a range using a criteria? Here's an example:
duda excel.JPG
I want to sum all the values in B2:C6 which are between and including G2 and G3.
Here's my formula: =SUMIFS(B2:C6,A2:A6,">="&G2,A2:A6,"<="&G3) but it returns a #Value! error
Any suggestions? Thank you very much!
Bookmarks