# SumIF formula with criteria is Text inside a Formula?

1. ## SumIF formula with criteria is Text inside a Formula?

If I have a ="Date: "&TEXT(B90," mm/dd/yy ")&SUM(C91:C102) inside Column C but I want a Total Cell in column D to Sum data above in column D, where a specific Text is inside column C... how would that work?

This is not working =SUMIF(C6:C102,"D*",D:D)

2. ## Re: SumIF formula with criteria is Text inside a Formula?

You can't mix ranges, they need to be the same size.

=SUMIF(C6:C102,"D*",D6:D102)

3. ## Re: SumIF formula with criteria is Text inside a Formula?

thanks Jeff, i tried that it still does not seem to find the rows with the Text inside the Cell/Formula of "Date". Everything eighth rows ( could vary later) has this formula in it:

="Date: "&TEXT(A104," ")&" Total: "&SUM(C92:C103)

4. ## Re: SumIF formula with criteria is Text inside a Formula?

thank you for your help...i got it to work!

5. ## Re: SumIF formula with criteria is Text inside a Formula?

You are very welcome and thanks for the feedback

------------------------------------------------------------------------

New quick method:

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1