For calculating purchase of new goods in a fleet, I want to check all previous years if goods need to be replaced.
I looked a lot to try to find an answer but my question is difficult to describe in Google :-(
See below example
I tried below formula, but it doesn't work. Any idea's?Please Login or Register to view this content.
=H2-G2+SUMIF($C3:G3,"=" & (COLUMN(CurrentCell)-COLUMN(G3)+1),$C4:G4)
All help greatly appreciated!
Bookmarks