Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SUMIF and SUMPRODUCT

Status
Not open for further replies.
marcie319

marcie319

Technical User
Oct 7, 2005
2
US
Hi, I am a new member!

Could someone please explain the difference between a SUMIF and SUMPRODUCT function in Excel?

thanks!!!

 
Sort by date Sort by votes


Hi,

SUMPRODUCT can operate on multiple column conditions.

Skip,

[glasses] [red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Formula with & and a single quote 2
Replies
4
Views
755
OzFoxy
OzFoxy
R
  • Locked
  • Question
Issues with Outlook default account and performance
Replies
0
Views
469
radleymartinez
R
cneill
  • Locked
  • Question
Combining If and Iferror and Index/Match with Hyperlink
Replies
18
Views
537
cneill
cneill
pendle666
  • Locked
  • Question
Microsoft Word - removing index entries with find/replace and wildcards
Replies
4
Views
3K
pendle666
pendle666
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
390
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top