Previous Topic Next Topic

Help with Sumif function please..

Closed
sterjohn Posts 1 Registration date Thursday January 7, 2016 Status Member Last seen January 7, 2016 - Jan 7, 2016 at 09:49 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Jan 9, 2016 at 06:16 AM
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
Related:

1 response

Answer 1 / 1
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Jan 9, 2016 at 06:16 AM
Hello,

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

Best regards
0

Similar discussions

"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response