Prerequisite
Please refer to Microsoft help for Syntax.
=SUMIF(range,criteria,sum range)
=SUMIF(range,criteria,sum range)
Possible Usage
SUMIF is a versatile formula and can be used in different needs.
Example is using SUMIF in two column of data.
Other option is to type the machine number in one cell and use formula. For example =SUMIF(D:D,A2,E:E)
The formula can be used to calculate the quantity produced by every machine.
DONE
Need to calculate the quantity produced by machine 3.
The steps (How to do)
1. type =SUMIF(D:D,3,E:E) in B2
Other option is to type the machine number in one cell and use formula. For example =SUMIF(D:D,A2,E:E)
The formula can be used to calculate the quantity produced by every machine.
DONE
ExpiresDefault access plus 1 year
Great continuation of the SUMIF topic! I’ve been using SUMIF for basic calculations, but your tips really open up new ways to leverage it. RKE2 looks like a powerful tool to enhance my Excel efficiency even more!
ReplyDelete