Sumif Function

H

hbroussard

Trying to use the sumif function to sum multiple columns using criteria in a
seperate column. See below.

1 2 15
1 1 16
2 3 15

Tried using sumif(c1:c3,15,a1:b3) and this did not work. If the column C
equals "15" then I need to sum both columns A and B. Any help would be
appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
SumIf equation question 6
Sumproduct? 3
Using SUMIF with dates 12
Sumif apllying to all sheets in workbook 2
sumif issues 1
SUMIF 8
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3

Top