# Get instant live Excel expert help with SUMIF functions

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## 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. Tradesmart £50 Tradesmart £60 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