sum if and subtotal not working

adam80 · Jan 20th 2018

can anyone help why this formula not working.
=SUBTOTAL(9,SUMIFS(X$4:X$192,$U$4:$U$192,"787")+SUMIFS(X$4:X$192,$U$4:$U$192,"752")+SUMIFS(X$4:X$192,$U$4:$U$192,"779")+SUMIFS(X$4:X$192,$U$4:$U$192,"780"))

thanks

**AliGW** · Jan 20th 2018

Hard to say without seeing the file, although the references are not correct for the SUMPRODUCT function. Attach the file and we can advise.

**iwrk4dedpr** · Jan 20th 2018

Moving to appropriate help forum.

sum if and subtotal not working

Participate now!

Share