Here are some problems that our users have asked and received explanations on
I am trying to write a sumif formula with dates. I have a range of dates in column A and sets of figures in other columns. I want to sum the figures in a particular column if the dates in A are between 1st-30th April, for example. Spent all afternoon swearing at it so far!
Solved by D. E. in 24 mins
I have some data I wish to sort into a list BUT… in column A are vendor names vertically i.e Tradesmart and then horizontally across the top are individual project numbers in each column.
Horizontally some projects have different costs for the same vendor. What I need to do is get a list which has the vendors in column a and the costs in column B, if the vendor has two projects with costs then it needs to appear twice with the different costs. For example: If Tradesmart has costs in project 1235 and 1245 then it should appear as follows in column A and B as follows.
If I use a Hlookup it will simply pick the first cost it finds for that vendor and If I use a SUMIF it will sum a total under one vendor but I need it split out and to repeat the name if it appears under several project numbers. It could very well be that some vendors only have one cost under one project in which case making a list wouldn’t be an issue. Also one step further would be to put the relevant project number in column C next to the corresponding Vendor and cost. This is simply rearranging the way the data appears but right now I’m having to do this manually and its taking a very long time.
Any help someone can offer would be highly appreciated.
Solved by Z. Y. in 11 mins
Several questions on Round formulas, SumIf, etc using the raw data set on the second tab
Solved by A. W. in 13 mins
My offset sumif date is returning a value and i cant figure out why
Solved by B. B. in 29 mins
is there a way to combine a sumif and a countif function together:
=SUMIF('Store Data'!BM:BN,"*"&B21&"*",'Store Data'!BL:BL(COUNTIF('Store Data'!BQ:BQ,"Yes")))
Currently the above formula returns the answer #REF
Solved by S. H. in 16 mins
Hi I'm having issues with sumif two criteria. can you please help me?
Solved by K. U. in 22 mins
Can you use the SUMIF formula but eliminate the results from one cell?
Looking to have the highest number of five and drop the lowest number of the fifth.
Solved by V. D. in 24 mins
Enter a SUMIF() formula in cell B9(column heading: Qtr_1) to calculate the total sales for Quarter 1 for the salespersonin cell A9. Your formula should sum up all sales for the salesperson in cell A9 for Quarter 1(Quarter 1 sales data is found in worksheet “Sales”, column D). The salesperson in A9 may have a number of sales in Quarter 1. Your SUMIF formula should total them all up.
Solved by S. W. in 21 mins
need help with sumif multiple columns. provide sumif excel example might be great
Solved by F. Y. in 22 mins
I'm trying to build a spreadsheet that will take data from individual acquisitions. Can I share the spreadsheet and ask what is wrong with my formula? I'm using a SUMIF function, but it's not working.