sumif & sumifs

[royalace]

I have been able to work with these with some success. What I am having trouble with is getting the formula to use more than one column to choose the data from.
formula =sumifs(tkcol,tkno,dola,dolb,dolc) where tkcol is the truck range, tkno is the truck to match, and the last 3 will have dollar amounts depending on what column it falls in. keep getting an error. any help on this. Thanks.

 

[Joe4]

Welcome to the Board!

Try this:

[COLOR=#333333]=sumif(tkcol,tkno,dola) + [/COLOR][COLOR=#333333]sumif(tkcol,tkno,dolb) + [/COLOR][COLOR=#333333]sumif(tkcol,tkno,dolc)[/COLOR]

 

[bellman101]

Hi royalace,

So you are summing trucks? just checking this is correct. can you give an example of what the formula would actually look like, dollars and all?

Cheers
JB

 

[royalace]

Welcome to the Board!

Try this:

[COLOR=#333333]=sumif(tkcol,tkno,dola) + [/COLOR][COLOR=#333333]sumif(tkcol,tkno,dolb) + [/COLOR][COLOR=#333333]sumif(tkcol,tkno,dolc)[/COLOR]

Thank you Joe4, used this format and was able to get all the info that was needed.

 

[Joe4]

You are welcome!

Note that SUMIFS works on multiple conditions, and all conditions must be met to return something (works like "AND").
If you have a situation like you have or want an "OR" condition, you can do separate SUMIF calculations and add them up.