Help with Sumif function please.. [Closed]

Report
Posts
1
Registration date
Thursday January 7, 2016
Status
Member
Last seen
January 7, 2016
-
Posts
7073
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 24, 2020
-
Could someone please help me??
I need to sum the values of a range of cells that contain certain text (product codes) into another cell.
For example a1,a2 and a3 might contain the letters "ahf" with a corresponding amount of $2, $4 and $10 in cells b1, b2 and b3.

Is there a way that I can have excel sum the totals of a given group of product codes into another cell? (sum the total of "ahf" into c3 for instance?).

Any help would be very much appreciated.
Kind regards,
John.S

1 reply

Posts
7073
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 24, 2020
498
Hello,

Try with this formula :
=SUMIF(A1:A5,"ahf",B1:B5)
You will find explanations about this function on Microsoft Office website

Best regards