Hi there,
I have the following formula:
I basically want this formula to do what it's currently doing, however only add up cells <0 only.![]()
=SUMPRODUCT(SUMIF(Data!A:A,$G$4:$O$4,Data!G:G),$G5:$O5)
The above formula is giving a cumalative total, so -20, -30, -50, 150 would = 50....I need it to show -100.
Hope this makes sense. I can post my spreadsheet if not.
Many thanks
Sam
Bookmarks