Show cells used in sumif

Hi

I'm using the sumif statement to sort out my bankstatemet - i'm in the need of being able to see which cells are added together in the sumif.

I have tried using F5 (Go-to special) but that just highligts the entire column i'm using as my range - any idea to how this is done.

My formula is: =SUMIFS($C$2:$C$1852;$B$2:$B$1852;"Husleje*";$F$2:$F$1852;J8)

/Jesper

You can use Conditional formatting
Select C2:C1852 & use this formula
=AND(B2="Husleje*",F2=$J$8)

Thanks - I'm quiet able to get it to work, but will give a go more.
I have around 30 different sorting tags times 12 month so I was hoping for a simpler sollution.
/Jesper

Can you please supply a sample file.


Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi

I have made a sample with test data - the size is not a big as the actual sheet but the concept is the same.

/Jesper

Ok, thanks for the file.
With Cf the formula should be
=AND(ISNUMBER(SEARCH($G$3,B2)),$D2=$H$2)
2 other options
1) Filter the records with the autofilter
2) a Macro if your happy with that.

I've added the first 2 CF formulae & I've also changed the formula in H3