# Problem with Formula

Hi I am trying to use this formula to sum together all of the values that meet a criteria defined in O10.

=SUMIF(Sheet3!N:N, ">" &O10)

I want to now update the formula to sum together all of the values between two values - however the below does not work - what am I doing wrong? It keeps saying there are too few arguments!

=SUMIFS(Sheet3!N:N, "<" &O10, Sheet3!N:N, ">"&O12)
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
HI,

pls try

=SUMIFS(Sheet3!N:N, Sheet3!N:N, "<" &O10, Sheet3!N:N, ">"&O12)

EDIT for reference
https://support.office.com/en-sg/article/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b

Regards
0
Commented:
Yeah you need 1 more argument. The syntax for sumifs is,

=SUMIFS ( Sum Range, Criteria Range1, Criteria1, Criteria Range2, Criteria2,...)

I'm assuming your Sum Range is Sheet3!N:N and your criteria is O10 and O12. That means you need the criteria ranges (the ranges that may contain the values in O10 and O12)
0

Experts Exchange Solution brought to you by