Need help on creating a function that meets criteria and give total.
I would like to add what is in columns D,F,H,J,L,N,P if the adjacent column has "R" in the field.
For example if E2="R" then add D2 and if G2="R" add F2, etc, etc
Excel.png
Thanks
Need help on creating a function that meets criteria and give total.
I would like to add what is in columns D,F,H,J,L,N,P if the adjacent column has "R" in the field.
For example if E2="R" then add D2 and if G2="R" add F2, etc, etc
Excel.png
Thanks
Hi,
i presume from your attachment that by 'adjacent' you actually mean subsequent.
Try this array formula (important that you know how to enter this type of formula in Excel):
=SUM(IF(D2:Q2="R",C2:P2))
Regards
The formula doesn't work. It just shows as text in the cell.
Hello
I find you can do this with Sumif without entering as an array if you prefer not to use them>
DBYPlease Login or Register to view this content.
"The formula doesn't work. It just shows as text in the cell."
Then perhaps your cell is formatted as text (?).
Regards
The formula given above adds all of the fields. I want it to do the following:
I want it to add only the columns that have an "R" in the adjacent column to it.
So since E2 is an R it would add D2 to the total, etc...
Did you verify whether the cell containing the formula I posted was not formatted as text?
Did you also ensure you entered it as an array formula (are you sure you know how to do this)?
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks