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 with the networkdays in it but im lost.

I alredy have  =IF(OR(P794="";AE794="");"";NETWORKDAYS(P794;AE794))

Is it possible to add a SUMIF or similar to select Bug in column A?

 

Br

Mon

excel
Formulas and Functions

4 Replies

  • 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),""))