Hi,
I am looking for a way to exclude the columns where "Group Quality" is included.
I'm using this formula. The wildcard should be a part of the SUMIFS part of the formula.
Formula:
=IF(EOMONTH(TODAY();-1)>=V$2;SUMIFS($R$3:$R$10;$Q$3:$Q$10;$B3;$S$3:$S$10;V2);C3)
I'm attaching an sample. the formula is in the green cells.
Project A - Group Quality |
Project A - Development |
Project A - GPDM |
Group Quality - Project A |
Project A - Development |
Project A |
Group Quality |
Project A - Development |
thanks,
Thomas
Bookmarks