Sum Product Help

[BBAUGH800]

I'm trying to find the correct formula to sum text that meets two criteria. If C2:C1023 is Equal to TEXT from J8 and F2:F1023 is equal to TEXT J4 add up the total times J4 shows up in C2:1023. Any help will be greatly appreciated!!


=SUMPRODUCT(Sheet3!C2:C1023=J8,Sheet3!F2:F1023=J4,Sheet3!C2:C1023)


DDU Weekly-Year Tracking.xlsx

[AZ-XL]

=sumproduct((C2:C1023=j8)*( F2:F1023=j4)*Sheet3!C2:C1023)

[Ron Coderre]

You were close...Try this:

=SUMPRODUCT(--(Sheet3!C2:C1023=J8),--(Sheet3!F2:F1023=J4),Sheet3!C2:C1023)

or this:

=SUMPRODUCT((Sheet3!C2:C1023=J8)*(Sheet3!F2:F1023=J4)*Sheet3!C2:C1023)

Is that something you can work with?

[Jonmo1]

Try

=SUMIFS(Sheet3!C2:C1023,Sheet3!C2:C1023,J8,Sheet3!F2:F1023,J4)

[Tony Valko]

The explanation is kind of

See if this does what you want:

=COUNTIFS(Sheet3!C2:C1023,J8,Sheet3!F2:F1023,J4)

[adyteo]

how do you want to sum TEXT? J4 is text, how can you calculate the SUM for text?
can you upload an example?

[Jonmo1]

Wait a minute....something doesn't make sense..

I'm trying to find the correct formula to sum text that meets two criteria. If C2:C1023 is Equal to TEXT from J8 and F2:F1023 is equal to TEXT J4 add up the total times J4 shows up in C2:1023. Any help will be greatly appreciated!!

How can C2:C1023 be equal to both J4 AND J8 ?
And if it's TEXT, it can't be 'added'

[Ron Coderre]

Too funny...I didn't even look at the logic of the formula. I just addressed the structure.

[BBAUGH800]

I'm trying to find if sheet 3 column F is "15 Customer Not Available" how many times has the customer not been available for the routes in Column C. With a break down of occurrence for each route on sheet 1.

[adyteo]

but that is not sum, that is a count.

Did you check Tony Valko's suggestion?

[BBAUGH800]

Thanks a lot Tony, sorry for the confusing post.

[Tony Valko]

No problem!

You're welcome!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.