can someone please help with this formula!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sunny - 10 Mar 2008 16:19 GMT

I have tried the function and played around with it abit but no luck,:

=IF('Events Due August'!B2:B1206,$C$3,SUMPRODUCT(--('Events Due
August'!F2:F1206='Customer Data Sheet'!B7))).

So I'm looking for the total number of events for a specific event
description e.g safety inspection for a specific customer which is where the
C3 in the customer data sheet comes in on my formula. Its just the IF part
where I need the end result by customer name which is causing me difficulties
as the rest of the formula works. What shall I do.

Reply to this Message

PCLIVE - 10 Mar 2008 16:38 GMT

If you are saying that you only want to perform the SUMPRODUCT equation on
only the rows where column B2:B1206=C3, then:

=SUMPRODUCT(--('Events Due August'!B2:B1206=$C$3),--('Events Due
August'!F2:F1206='Customer Data Sheet'!B7))

HTH,
Paul

>I have tried the function and played around with it abit but no luck,:
>
[quoted text clipped - 9 lines]
> difficulties
> as the rest of the formula works. What shall I do.

Reply to this Message

PCLIVE - 10 Mar 2008 16:43 GMT

Oops! I missed something.

Try this:

=SUMPRODUCT(--('Events Due August'!F2:F1206='Customer Data
Sheet'!B7),--('Events Due August'!B2:B1206='Customer Data
Sheet'!$C$3))

Regards,
Paul

> If you are saying that you only want to perform the SUMPRODUCT equation on
> only the rows where column B2:B1206=C3, then:
[quoted text clipped - 18 lines]
>> difficulties
>> as the rest of the formula works. What shall I do.

Reply to this Message