i need a formula to total up the quantity pump used on beside of the selected name of worker, the total is depend on each farm Acre and customer.
Please refer to the attachment, thanks very much.
i need a formula to total up the quantity pump used on beside of the selected name of worker, the total is depend on each farm Acre and customer.
Please refer to the attachment, thanks very much.
In G3 copy down to G11: =IF(OR(C3<>C2,D3<>D2),SUMIFS($E$3:$E$11,$C$3:$C$11,C3,$D$3:$D$11,D3),"").
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks