#sumifs

Hi everyone, At the moment I have this spreadsheet which I am using to calculate the income services and business expenses per category. It works great but I have been struggling to make work how I need it to function exactly. The table where all the services & expenses are summed by category...

Hi Everyone, I"ve been trying to figure out how to do this and been stuck for over a week. I created this custom report table, which works great. But the problem, I'm having is if I enter a "Start Date" which has a different year then my "End Year". It doesn't include the data from the...

Good evening, I have been working for about a week to see if I could get this formula to work. Currently I do have a SUMIFS formula in the cell, but I also want to enter another set of criteria and can't think of how to do it. What I'd like to add into the formula: In AA (where you see...

@ How to Get Period-wise Stock N3 =SUMIFS(E:E,C:C,L3,D:D,M3) ( IN) O3 =SUMIFS(J:J,H:H,L3,I:I,M3) (OUT)

=GETPIVOTDATA(SUMIFS(B4:B5,A4,"")-SUMIFS(C4:C5,A4,"")) I was trying Get data from pivot table, kindly Help to correction Formula... i was trying (PURCHESH NET WT-SALE NET WT) and getting Result... Get pivot data using "SUMIFS" FORMULA for Stock management. HELP ...

Hi there, I'm using this formula =-SUMIFS(BW!$F:$F,BW!$B:$B,"Essential Health",BW!$D:$D,'By MRC & SH'!F$4,BW!$E:$E,"Result") but as I drag it down the rows, I want the BW!$F:$F to be BW!$G:$G, BW!$H:$H and so on and everything else the same. Is it possible? I've made it look at a cell that has...

Hi there! I've been trying to figure this out for long but i cant, and hence i need help with this. My objective is to calculate YTD numbers from a set of MTD numbers. So example i have this set of data: I will need to sum the figures based on these five categories AND obtain the YTD...

Hi, Im stuck with a formula can anyone help? I want to sum the bottom row in the image below when two criteria is met, which is 'A' and 'Qty' The problem is the sum range needs to be the bottom row only(figures). The criteria 1 (A,B,C) is a merged cell if that makes any difference! Any ideas...