sumif formula

  1. S

    sumif based on if FORMULA contains

    Hi Everyone How can I do a sumif based on whether the formulas of the cells in a range contain a certain element? I have been given a spreadsheet with mixed formulas (created by a novice), such that I'd like to sum all the values that have $P in their formula. I approached it with...
  2. R

    Excel weird problem with SUMIF formula

    Hi everyone, I have a weird problem with SUMIF formula. My formula in cell R1046 is : =IF(SUMIF(C:C,C1046,L:L)=0,"paid","not paid" So, the basic is : If column C contains the value of the regarding row then calculate the value of column L. As we can see, inside the blue box - Excel...
  3. M

    SUMIF Formula Help

    As you can see in cells G2 & I2, I'm trying to do a continuous total from Column A if there is a "1" in Column C, or a continuous total from Column B if there is a "1" in Column D. I want the result to show in either G4 or I4. I tried this formula in G4, but it didn't work...
  4. Y

    How do I reference column header name from another worksheet instead of the letter

    First time posting here. I have an excel worksheet (I'll refer to it as "Data") from where I am pulling data on other sheets using Sumifs formula. Up until today I was downloading the raw data and pasting it on the "Data" worksheet. In my dashboard worksheet I am using Sumifs formula to look...
  5. S

    Sum if the first 5 characters match

    Hello, I am working with two tables (both shown below). I want to be able to populate Column B in Table 2 by writing a lookup (I assume it's a variation of SUMIF) that will look at the value in Table 2, Column A, match it with the first five characters in Table 1, Column A, and sum the values...
  6. N

    Dynamic SUMIF Statement

    hello,new to VBA so I was hoping someone could help me out. I've looked through this website and online and can't find a solution. The below Macro will run on different tabs so it will go through columns of different row numbers. Therefore, I need to make my SUMIF and ranges Dynamic so they...
  7. T

    Question on SUMIF vs SUMPRODUCT and how to return a total in one column based on values in other columns

    I have a massive excel spreadsheet of data that contains thousands of URLS and web performance data. My table structure is: Col B = Microsite Col I = URLs Col S = Total Page Views I am trying get extract the total in range S3:S1048576 where the values in range B3:B1048576 = "xyz", and the...
  8. E

    Sumif formula is changing my link to a table after I close the workbook

    I'm trying to write a sumif formula that is linking to a table and it keeps changing the formula once I save/close and then reopen the file. I highlight the column "Region" in my table (which is located in a different workbook) and it populates correctly in the formula and then when I reopen the...
  9. M

    Concatenate & SUMIF Formatting

    Using Excel 2013 on Windows 8 laptop... not sure what else you need. I've managed (I don't know how) to create this really cool formula in my file I use for my checkbook register to tell me the total balance that's cleared... but the formatting is wrong - and it's irritating me greatly! Any...
  10. I

    How to write sum if formula if criteria is a variable parameter?

    <colgroup><col><col span="3"></colgroup><tbody></tbody> I have a Table 1 which contained the sub account number and the related amount. The sub account numbers are then grouped to a master account number which is presented in Table 2. Table 2 is like a directory to guide what sub account numbers...
  11. C

    Replace SUMIF, not calculating

    I have a sheet that is a master billing for 4 properties. The sumif is used to create a subtotal for each column with a row for each property. in column B user puts in a property code that is the constant in a sumif. Is there a way to do this with out sumif. The issue I am having is that it...
  12. R

    sumif with three HLOOKUPs?

    <TBODY> Account</SPAN> DocumentNo</SPAN> Type</SPAN> Text</SPAN> Amount in doc. curr.</SPAN> 504520</SPAN> 1</SPAN> AD</SPAN> description1</SPAN> -55.00</SPAN> 504530</SPAN> 2</SPAN> </SPAN>XX description2</SPAN> 86.00</SPAN> 504540</SPAN> 3</SPAN> </SPAN>XX...
  13. U

    SUMIFS returns "0" incorrectly. How do I adjust Cell in VBA to return actual sum value?

    I made the following formula to automatically update a report to return Day, Week or Monthly values based on Cell B2 (Which changes based on user input from userform) =SUMIFS(Qty,Custodian,$B10,Defi,"Active Others",Age,C$4,Method,"Electronic",Rec_Rej,$C$3,day,$A$2). The columns have defined...
  14. L

    Horizontal Sum

    Need to do horizontal sum, (see example data block) <colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> Month1 Month1 Month1 Month1 Month2 Month2 Month2 Month2 Week 1 Week 2 Week 3 Week 4 Week 1 Week 2 Week 3...
  15. J

    Simplify this formula

    Is there away to get rid of all these SUMIFS and make this formula simpler and still get the same result. 445
  16. J

    Sumif frustrations

    Hi, I really like the sumif and sumifs but sometimes it just does not work as the cells i am trying to pick up are not found due to the criteria cell not matching although visually they both look the same. What steps can i take logically to solve this problem. Any shortcuts keys would be...
  17. I

    SUMIF, SUMPRODUCT, DSUM, ?? Please help

    To All: I would like to sum a column of values (column C, named range “ONRENT”). Column A contains my starting date (range named “OUT”). Column B contains my ending date (range named “IN”). Cell E2 will contain a random date. Cell F2 will contain the formula. The formula should return a total...
  18. J

    Trying to sum data that fits certain criteria

    I can't seem to figure this out. I'm trying to sum data that fits w/in two dates I've specified. Normally, this would be a simple sumif formula. But the data I'm actually summing has text string and so Excel doesn't see the numerical values to be able to add them. Here's what my data table...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top