I am trying to add numbers in column H IF the data in column E=AS FIN AND the
data in column B=Jan
I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.
Thanks for any help you can provide.
I am trying to add numbers in column H IF the data in column E=AS FIN AND the
data in column B=Jan
I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.
Thanks for any help you can provide.
Is this what you want?
=SUMPRODUCT(--(E1:E100="AS FIN"),--(B1:B100="Jan"),--(H1:H100))
"anike007" wrote:
> I am trying to add numbers in column H IF the data in column E=AS FIN AND the
> data in column B=Jan
>
> I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.
>
> Thanks for any help you can provide.
>
Hmmmm - I've tried SO many things but I can't seem to get anything to work....
I tried this but come up with a #Value! answer?!?!?!?!?
Toppers wrote:
>Is this what you want?
>
>=SUMPRODUCT(--(E1:E100="AS FIN"),--(B1:B100="Jan"),--(H1:H100))
>
>> I am trying to add numbers in column H IF the data in column E=AS FIN AND the
>> data in column B=Jan
>>
>> I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.
>>
>> Thanks for any help you can provide.
Check for #Value! errors in E1:E100l and B1:B100.
Check for non-numeric entries in H1:H100.
anike007 wrote:
>
> Hmmmm - I've tried SO many things but I can't seem to get anything to work....
>
> I tried this but come up with a #Value! answer?!?!?!?!?
>
> Toppers wrote:
> >Is this what you want?
> >
> >=SUMPRODUCT(--(E1:E100="AS FIN"),--(B1:B100="Jan"),--(H1:H100))
> >
> >> I am trying to add numbers in column H IF the data in column E=AS FIN AND the
> >> data in column B=Jan
> >>
> >> I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.
> >>
> >> Thanks for any help you can provide.
--
Dave Peterson
URGH!!!! So frustrating. Still not working.... ??? :-(
I've checked everything I know to check?? Thanks for trying!
Dave Peterson wrote:
>Check for #Value! errors in E1:E100l and B1:B100.
>
>Check for non-numeric entries in H1:H100.
>
>> Hmmmm - I've tried SO many things but I can't seem to get anything to work....
>>
>[quoted text clipped - 10 lines]
>> >>
>> >> Thanks for any help you can provide.
>
--
Message posted via http://www.officekb.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks