COUNTIF & SUMIF formulas needed when decided based on entry into 2 cells

**excelteam777** · 08-18-2013, 07:23 PM

I need 2 separate formulas. Basically once I have either the sumif or countif then I can change it accordingly. Lets say for this example I need the sumif.

For this example we will use columns A1:A10, B1:B10, C1:C10, & D1
A&B = the data
C = random number to input
D = formula - the sumif

A = an employee ID number say “2”
B = an item say “apple”
C1:C10 = $1,000 in each cell
If I enter the number “2” in A1-A5 (in 5 cells) & “apple” only in B1, B2 & B3 (3 cells)
Then D1 should = $3,000 to sum only when both columns have the correct sumif data.

**FDibbins** · 08-18-2013, 07:34 PM

Take a look at the help on using sumifS(), or see the guide as you enter the data.

The syntax is...
=sumif(sum-range,criteria-range1,criteria1,criteria-range2,criteria2)
so maybe something like...
=sumifs($C$1:$C$10,$a$1:$a$19,2,$B$1:$B$10,"apple")

**excelteam777** · 08-18-2013, 07:54 PM

thank you, works great

**FDibbins** · 08-18-2013, 07:58 PM

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)