• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum

ridwanr

New Member
Hi all.

I have an excel sheet where there are several headers and at the the I need the total of the header CALL BACK+IGNORE+CANNOT USE.

The thing is that the column constantly change everyday by adding new elements(header) depending when I download my database. Thus I was thinking if there was a formula in excel that can take only the headers that I name into consideration and do the sum up whatever the number of columns that is added.

Plz see attachment for better understanding.

Thanks and regards,
Ridwan
 

Attachments

  • Sumup formula.xlsx
    11.3 KB · Views: 6
In I12 and pull down =SUMPRODUCT(--($B$11:$H$11="callback")*$B12:$H12)+SUMPRODUCT(--($B$11:$H$11="ignore")*$B12:$H12)+SUMPRODUCT(--($B$11:$H$11="cannot use")*$B12:$H12)
(There must be a shorter way)
 
Hi to both!

Another way could be:
Java:
=SUM(SUMIF(B$11:H$11,{"Callback";"Ignore";"Cannot use"},B12:H12))
or
Java:
=SUMPRODUCT((B$11:H$11={"Callback";"Ignore";"Cannot use"})*B12:H12)
or (Microsoft 365):
Java:
 =SUM(XLOOKUP({"Callback";"Ignore";"Cannot use"},B$11:H$11,B12:H12))

Blessings!
 
Back
Top