Conditional Formatting with Ranges of Corresponding Data

[ExelDummy]

I am trying to accomplish the following conditional formatting and need some help please.

In worksheet1, when cells F5-F13=CustomerName, I need the corresponding data from cells D5-F13 (order amount) to be subtotaled in cell C5 of worksheet 2.

Please let me know if this makes sense.

Thanks,

[Olly]

No, that doesn't make sense.

First of all, you can't create a subtotal with conditional formatting - you need to enter a formula in Sheet2!C5.

Now, to work out exactly what that formula should be, we need to understand your criteria a little better.
Are you saying that you want a sum of range Sheet1!D5:F13 IF all the cells in range Sheet1!F5:F13 contain CustomerName??

[ExelDummy]

Olly,

Thanks for the reply.

The range in f5-f13 in sheet 1 is mixed with different customer names. The corresponding range d5-d13 contains the order amount of that customer. In sheet 2 c5 I want it to add up only the d5-d13 cells in sheet 1 that are for that specific customer.

Does that help?

[Olly]

Very nearly... The only missing bit of information now is what you mean by "that specific customer"!

e.g. in Sheet2!C5, enter:

Please Login or Register  to view this content.

You can replace "CustomerName" with a cell reference containing the customer you wish to subtotal.

[ExelDummy]

Very nearly... The only missing bit of information now is what you mean by "that specific customer"!

e.g. in Sheet2!C5, enter:

Please Login or Register  to view this content.

You can replace "CustomerName" with a cell reference containing the customer you wish to subtotal.

This worked Olly! Thanks, now if the data ranges of F5-F13 & D5-D13 are the same across multiple worksheets, how would I add them to the formula?

[Olly]

By repeating the SUMIF element for each worksheet:

Please Login or Register  to view this content.

etc...

[ExelDummy]

Awesome, this was a huge help, thanks Olly!

[Olly]

Awesome, this was a huge help, thanks Olly!

My pleasure. Glad you're sorted