EXCEL FORMATING HELP

[nikaiyo2]

I am trying to write a conditional formula.
I don't think Vlookups will work as I want to look at data in multiple columns.

SUMIF($C$3,'241115'!O3,'241115'!K3)+SUMIF($C$3,'241115'!O4,'241115'!K4)

So my check vale is $C$3, matching in column O returns K if match. All good.
I then want to run down the columns and if the result of O4 match $C$3 return K4.

Can I do this without adding another sum and changing the O & K? I have pages and pages of data i want to drill into

[sideways sid]

Not sure what you're trying to achieve because nothing in the text relates to formatting, but try this formula, replacing "999" with the last row in which you have entries for columns "O" and "K":

=SUMPRODUCT(($C$3='241115'!O3:O999)*('241115'!K3:K999))

Edited:

Just re-read your post and I think your SUMIF was a red herring!

I think you just want a column of values in column K, but only if the corresponding value in column O, is equal to the value in C3

=IF($C$3='241115'!O3,'241115'!K3,"")

"" will give no value. Depending on type of data and what you're doing with it, replace "" with zero.

Edited by sideways sid on Thursday 6th June 14:27

[nikaiyo2]

Hi sideways sid


Yup nothing at all to do with formatting should have wrote formulas

I took a formula I wrote a few years ago and tried to mod it...

The SUMPRODUCT is spot on, it does what i was hoping and adds the values of the cells if a criteria is met.

Thanks for your help.

[sideways sid]

You're welcome.

People are always providing me with help on here directly or indirectly, so its nice to return the favour.