Ok i need help with a formula. I am analyzing column C. every time the text "2.5" appears in C I need to report the value of the corresponding cell from column D. Example : c26 and c39 have the text "2.5" in them, so I need to add up the total of cells D26 and D39.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Analyzing multiple cells and reporting values.
- Thread starter DANNYB667
- Start date
-
- Tags
- analyze multiple critera
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,796
- Office Version
- 365
- Platform
- Windows
Use the SUMIF formula, i.e.
See: MS Excel: How to use the SUMIF Function (WS)
Code:
=SUMIF(C1:C100,"2.5",D1:D100)
Upvote
0
Similar threads
- Question
