Hi guys,
I am trying to sum a few columns together with a criteria. Can someone please offer guidance on the formula I should use please?
my sheet attachd.
I want a formula in cell IC26 please to add cells from the holiday payment column (column IC) if the column HR to pay? (column IG) has yes inserted. Another caveat.. for test 11 (row 13), I need to add use IJ13 instead of IC13... so values in column IJ should prioritise column IC.
Can someone help please/
thanks!
Bookmarks