Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I hope someone can give me a hand here. I have the following: D E F G H I J K 5 10 601 8 601 3 614 4 601 I want to program a cell that will add up D5, F5, H5, J5 only if text in E5, G5, I5 and K5 is "601", so that my result should be 22 Thanks for your assistance Markus |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumif based on value in cell | Excel Worksheet Functions | |||
Contains a Value Cell and Sumif? | Excel Worksheet Functions | |||
SUMIF with a reference to a cell | Excel Discussion (Misc queries) | |||
SUMIF cell = "Yes" | Excel Discussion (Misc queries) | |||
SUMIF, wildcard and cell ref | Excel Worksheet Functions |