Formula Help

[marcidee]

Can someone help me 'tweak' this formula to only 'sum' if it sees a '3' in column AP? =SumCellsByColor(B27:AL27, $AV$4)

Your help would be very much appreciated

Marc

 

[James006]

Regarding your New Function ...

you do need to to use it as follows :

=SumCellsByFontColor(B4:AL4, $AV$4, AP4)

 

[marcidee]

Thank you for your patience - I have tried that - I do not get any error messages - however it still adding in the coloured cells that have a 1 or 2 in column AP (results are in AQ if that is relevant, coloured cells are B to AL)

formula in AP is =CountCellsByColor(B4:AL4, $AV$4)
formual in AQ is =SumCellsByColor(B4:AL4, $AV$4)

Yes - that is what I have done - I have 6 functions - the last is yours (replacing the previous). No errors - but still shows a result if 1 or 2 is in column AP

 

[James006]

Quite difficult for me to guess what there is in front of your eyes ... :wink:

Would you have the possibility to upload a sample file ...

to a free site ... such as www.box.com or www.dropbox.com

 

[marcidee]

This now gives me the desired results if there is a 1 or 2 in = but it is not giving me the correct result if there is a '3' (on line 4 for example I should be seeing 125 and it gives me 330,lie 5 should be 193 and it gives me 276)

 

[marcidee]

Here is a link to the file https://mab.to/95UfUFX82

 

[James006]

Sadly the link you posted is not working ...