Forum Discussion

Master_of_non's avatar
Master_of_non
Copper Contributor
Nov 26, 2019
Solved

NETWORKDAYS only for rows with a specifik name in field

Hi all,   Im a newbee and need help with a formula.   Im trying to count the networkdays in a list but I only want it to work on the rows with the status bug in column A. Ive tryed some SUMIFS wi...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 26, 2019

    Master_of_non 

    As variant

    =IF( (A794="bug")*P794*AE794; NETWORKDAYS(P794;AE794); "")

     

mathetes's avatar
mathetes
Gold Contributor
Nov 26, 2019

Master_of_non 

 

Try this, the changes highlighted in underlined bold  (and if it doesn't work, could you upload a sample file rather than just an image). I'm just assuming your "NETWORKDAYS" function works already; didn't test it.

=IF(OR(P794="";AE794="");"";IF(A769="bug",NETWORKDAYS(P794;AE794),""))