i am calculating sum of profits (column O) based on the list of comments as u can see from column V. this is working fine. now i want to add additional criteria where i want it to sum up for me based on week number of the closing date in column D, eg week 25. 25 will be hardcoded for now. i tried for few days but failed. please send help. i have a feeling this is a simple solution.
my current formula:
=SUM(SUMIF($Q$15:$Q$2865, V3:$V$10, $O$15:$O$2865))
thanks in advance!
i am calculating sum of profits (column O) based on the list of comments as u can see from column V. this is working fine. now i want to add additional criteria where i want it to sum up for me based on week number of the closing date in column D, eg week 25. 25 will be hardcoded for now. i tried for few days but failed. please send help. i have a feeling this is a simple solution.
my current formula:
=SUM(SUMIF($Q$15:$Q$2865, V3:$V$10, $O$15:$O$2865))
thanks in advance!
i am calculating sum of profits (column O) based on the list of comments as u can see from column V. this is working fine. now i want to add additional criteria where i want it to sum up for me based on week number of the closing date in column D, eg week 25. 25 will be hardcoded for now. i tried for few days but failed. please send help. i have a feeling this is a simple solution.
my current formula:
=SUM(SUMIF($Q$15:$Q$2865, V3:$V$10, $O$15:$O$2865))
thanks in advance!
