SUMIFS Value error

[FinanceGuy007]

Hi Guys,

I have used SUMIFS many times before without any issues but cant seem to understand why it is errors out (#VALUE! error) in the following formula. All my ranges are the same size, Column K is TEXT format although not sure why this would have any impact. Column O is also in TEXT format. I have tried modifying the formula to a single criteria SUM to inspect the components and it seems fine. when i use the SUMIFS it doesn't seem to like it:

=SUMIFS($C$12:$C$1000,$O13,D$12:D$1000,K12:K1000,$O$10)

I tried to paste a screenshot but it will not allow me to. hopefully the problem formula below is enough?

Appreciate any help!

 

[Tetra201]

SUMIFS syntax:

SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)

 

[Aladin Akyurek]

You don't seem to have a sum range, i.e. a range to sum that SUMIFS expects. If D2:D1000 is meant to be summed, try...

=SUMIFS(D$12:D$1000,$C$12:$C$1000,$O13,$K$12:$K$1000,$O$10)

 

[FinanceGuy007]

You don't seem to have a sum range, i.e. a range to sum that SUMIFS expects. If D2:D1000 is meant to be summed, try...

=SUMIFS(D$12:D$1000,$C$12:$C$1000,$O13,$K$12:$K$1000,$O$10)

Thanks Aladin! Glaringly obvious and yet I couldn't see after starting it at for close to 30 minutes it till you pointed it out. Duh moment!

best
FG

 

[FinanceGuy007]

Thanks Tetra. Ive used this so many times I forgot the basics!

 

[Aladin Akyurek]

Thanks Aladin! Glaringly obvious and yet I couldn't see after starting it at for close to 30 minutes it till you pointed it out. Duh moment!

best
FG

Such can happen. Thanks for the update.