asked on

Sum Cells against specific criteria in other Cells

Hi,

I am looking for a formula that sums up Searches in Column B that are in between cells containing http in Column A...

Note: the numbers of cells to sum up is always different. The Webpages names are never the same.

Any help would be appreciated.
Thanks in advance
20120416-SumCellsWithCriteriaInO.xlsx

Saqib Husain

Try this ARRAY formula in C2

=IF(B2="",SUM(OFFSET(B2,1,0,MATCH(0,--B3:B42,0))),"")

To enter an array formula:
enter the formula in the cell
select the cell
press F2
press shift-ctrl-enter

fredericgilbert

ASKER

Hi ssaqibh,

Thanks for the proposed solution but it covers only partially the situation.
Most certainly, my request and the associted excel was too simplified and not explicit enough.

The sum result should be in same column as the values to sum up, just above them as a total and the criteria triggering the sum up is the presence or not of "http" in column A.

There is 2 parts to the formula I am looking for:

1. when http is detected, it sums up the Monthly Searches' cells below.
>>This is the part that I looking or help.

2. when http is not detected, the formula is getting the Monthly Searches from in a pivot elsewhere in the workbook (I have that part ok with the getpivotdata)...

Question: can this be done in the same column without helper column?

Thanks

ASKER CERTIFIED SOLUTION

Saqib Husain

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Saqib Husain

2. when http is not detected.....

Can you show me how?