Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF
i want to do a conditonal sumif only searching on the first 13 characters of
the items in the list. ie. "Total Revenue" of what might be "Total Revenue - All SE Accounts" How can I use a variable instead of a fixed value to search on? Any ideas on how I might be able to do this? Thanks in advance. Joe |
#2
|
|||
|
|||
Using what I leaned from a previous message this morning:
=SUMPRODUCT((LEFT(H2:H5,13) = "total Revenue")*(I2:I5)) "Joseph" wrote in message ... i want to do a conditonal sumif only searching on the first 13 characters of the items in the list. ie. "Total Revenue" of what might be "Total Revenue - All SE Accounts" How can I use a variable instead of a fixed value to search on? Any ideas on how I might be able to do this? Thanks in advance. Joe |
#3
|
|||
|
|||
As with the SUMIF question asked a few minutes ago try:
=SUMPRODUCT((LEFT(F1:F10,13)="Total Revenue")*(G1:G10)) HTH Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "Joseph" wrote in message ... i want to do a conditonal sumif only searching on the first 13 characters of the items in the list. ie. "Total Revenue" of what might be "Total Revenue - All SE Accounts" How can I use a variable instead of a fixed value to search on? Any ideas on how I might be able to do this? Thanks in advance. Joe |
#4
|
|||
|
|||
=SUMIF(ItemRange,"Total Revenue*",SumRange)
Joseph wrote: i want to do a conditonal sumif only searching on the first 13 characters of the items in the list. ie. "Total Revenue" of what might be "Total Revenue - All SE Accounts" How can I use a variable instead of a fixed value to search on? Any ideas on how I might be able to do this? Thanks in advance. Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
help with "criterea" in the sumif function | Excel Worksheet Functions | |||
SUMIF between dates | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |