Multi option sum

[shanakhtar]

Dear Friends,

I want to sum data in COLUMN C that is related to COLUMN B if the COLUMN F is blank.

Thanks in advance

[davesexcel]

Search for sumproduct, this function will do what you need.

[shanakhtar]

Search for sumproduct, this function will do what you need.

I have tried SUMPRODUCT but unable to execute it properly can u give example according to the attached sheet.

[shanakhtar]

anyone there?

[pmguerra]

You can also try using a Pivot Table to sum up the invoices and display the information as you want (name of firma, value, ...)

[shanakhtar]

pmguerra

ANY EXAMPLE???

[davesexcel]

=SUMPRODUCT(($B$4:$B$31=B36)*($D$4:$D$31="---")*($C$4:$C$31))

Placed in C36 then dragged down.

[pmguerra]

What is the difference between "blank" and "---" ?

[davesexcel]

What is the difference between "blank" and "---" ?

You wouldn't ask that if you looked at the workbook.

[pmguerra]

You wouldn't ask that if you looked at the workbook.

I did the look at the workbook hence the question... Besides you had already come up with a solution when I was typing my reply.

Anyway, you replied 4 times in this thread. 2 out of 4 were (let me put it nicely) not useful replies. I don't think that's the role of a Forum Moderator but that's just me.

I was going to ask you about the SUMPRODUCT function you used because I didn't really understand how it works but I'm sure you have other threads to answer in such a "smart" and cunning way...

Take care!

[Paul Morgan]

...I did the look at the workbook hence the question...

Looking at the workbook supplied, it appears the cells that were considered blank, were not blank, they had the text "---".
As this is the case, did you really look at the workbook as closely as you say you did?