Skip to main content

SUMIFS

The SUMIFS function in Excel is a function that allows you to sum the values in a range of cells based on multiple criteria. The syntax for the SUMIFS function is as follows: SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...). The "sum_range" is the range of cells that you want to sum, and each "criteria_range" and "criteria" pair specifies a criterion for including a cell in the sum. For example, to sum the values in the range A1:A10 where the values in the range B1:B10 are greater than 5 and the values in the range C1:C10 are less than 10, you would use the formula =SUMIFS(A1:A10, B1:B10, ">5", C1:C10, "<10").      
Labels:

Comments

Post a Comment

Popular posts from this blog

Get multiple lookup values in single cell

Post a Comment
Read more

Rupees into words

Option Explicit Function RupeesInWords(ByVal MyNumber As Double) As String Dim Rupees As String Dim Paise As String Dim Temp As String Dim DecimalPlace As Integer MyNumber = Round(MyNumber, 2) DecimalPlace = InStr(MyNumber, ".") If DecimalPlace > 0 Then Rupees = Left(MyNumber, DecimalPlace - 1) Paise = Mid(MyNumber, DecimalPlace + 1) Else Rupees = MyNumber Paise = "" End If RupeesInWords = "" If Val(Rupees) > 0 Then RupeesInWords = ConvertToWords(Rupees) & " Rupees" End If If Val(Paise) > 0 Then RupeesInWords = RupeesInWords & " and " & ConvertTwoDigits(Left(Paise & "00", 2)) & " Paise" End If RupeesInWords = Application.WorksheetFunction.Trim(RupeesInWords) & " Only" End Function Private Function ConvertToWords(ByVa...
Post a Comment
Read more