Using a Logic Function in SUMIFS

[phillygirl777]

Hello,

I need to sum the values when the first characters are numeric:

=SUMIFS('Data Tab'!C:C,'Data Tab'!A:A,$A2, 'Data Tab'!B:B,

 

[vletm]

Do You need this thread?
OR
Is this different than Your next one?

P

Thread 'HELP with SUMIFS'

Monday at 4:54 PM

Hello,

I know that there is an error and it's no the right way to do it, but how do I incorporate the text value function into my SUMIFS formula? I need to get a sum of the numbers if the first 2 characters of a cost center are numeric vs letters. Here is what I got so far (I know it's not right - need help with the right-most function):

=SUMIFS('Data Tab'!C:C,'Data Tab'!A:A,$A2,'Data Tab'!B:B,ISNUMBER(VALUE(LEFT('Data Tab'!B:B,2))))

Please help with the red part of the formula. I am getting a #SPILL! error.

Thank you!

• phillygirl777
• Replies: 9
• Forum: Ask an Excel Question

 

[vletm]

Do not duplicate Your thread, please.
This thread is closed now.